From: Ragnar <gnari@hive.is>
To: Ashish Ahlawat <ahlawat.ashish@gmail.com>
Cc: Markus Schaber <schabi@logix-tt.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: join and sort on 'best match'
Date: Fri, 15 Dec 2006 19:46:47 +0000
Message-ID: <1166212007.6369.194.camel@localhost.localdomain> (raw)
In-Reply-To: <682126990612150840r409ada5y234ff3ef3ac85c5f@mail.gmail.com>
References: <457FC751.6080104@code-shop.com>
<1166005787.6369.79.camel@localhost.localdomain>
<682126990612140510j61d2268fq80235b02a550eccd@mail.gmail.com>
<20061214163659.088b7236@kingfisher.sec.intern.logix-tt.com>
<682126990612150840r409ada5y234ff3ef3ac85c5f@mail.gmail.com>
On fös, 2006-12-15 at 22:10 +0530, Ashish Ahlawat wrote:
>
>
> Hi team
>
> I was just asking that If table ITEM3 has all the columns then why we
> need to have a join ?? even we put a sorting very easily.
> On 12/14/06, Markus Schaber <schabi@logix-tt.com> wrote:
> Hi, Ashish,
>
> "Ashish Ahlawat" <ahlawat.ashish@gmail.com> wrote:
>
> > if table *Item 3 : news, nature, greenpeace, whale has all
> clmn y v need
> > join ??*
it seems these where not columns of a table.
the organisation was like this:
table items:
id name
-----------
1 foo
2 bar
3 item3
table tags:
tag_id text
---------------------
1 news
2 nature
3 tennisballs
4 greenpeace
5 cannibals
6 whale
and table items_tags:
item_id tag_id
----------------
3 1
3 2
3 4
3 6
...
so table items needs to be joined to table tags via
table items_tags to retrieve the connections from item3
to news, nature, greepeace and whales.
gnari
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gnari@hive.is, ahlawat.ashish@gmail.com, schabi@logix-tt.com
Subject: Re: join and sort on 'best match'
In-Reply-To: <1166212007.6369.194.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox