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.n...@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
