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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
