Using subselects as joins in POstgeSQL (possible?, examples)

Using subselects as joins in POstgeSQL (possible?, examples)

Is it possible to use subselects as joins in PostgreSQL.

eg.

select a.a, a.b, a.c, b.a, b.b. b.c from (first subsselect) a (second subselect)
b  where (in table criteria) and a.a = b.a

or

select a.a, a.b, a.c, b.a, b.b. b.c from (first subsselect) a join (second
subselect) b on a.a = b.a where (in table criteria)

I have a feeling it is possible but I need the right syntax

//Frank



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

Re: Using subselects as joins in POstgeSQL (possible?, examples)