Re: where clauses and multiple tables

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(dot)w(dot)noon(at)ntlworld(dot)com (David W Noon)
> =
> ======================================================================
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)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)