On Sep 8, 2009, at 4:02 PM, David W Noon wrote:
> On Tue, 8 Sep 2009 14:25:20 -0700, Scott Frankel wrote about [GENERAL]
> where clauses and multiple tables:
>
>> Is it possible to join tables in the where clause of a statement?
> [snip]
>> Given a statement as follows:
>>
>> SELECT foo.foo_id, foo.name
>> FROM foo, bar
>> WHERE foo.bar_id = bar.bar_id
>> AND bar.name = 'martini';
>
> Just use an IN predicate:
>
> SELECT foo_id, name FROM foo
> WHERE bar_id IN (SELECT bar_id FROM bar WHERE name = 'martini');
>
> This is frequently called a semi-join.
This looks very promising. Thanks for the info!
Scott
> --
> Regards,
>
> Dave [RLU #314465]
> =
> ======================================================================
> david.w.noon@ntlworld.com (David W Noon)
> =
> ======================================================================
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
Scott Frankel
President
Circle-S Studios
www.circlesfx.com
510-339-7477 (o)
510-332-2990 (c)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general