On Fri, May 26, 2006 at 09:09:25 -0700, John Taylor <[EMAIL PROTECTED]> wrote: > I have a select statement that goes as follows: > > SELECT * FROM product prod, prod_alias pa, category cat, company co > WHERE prod.catid = cat.catid > AND prod.coid = co.coid > AND prod.prodid = pa.prodid; > > If possible, I want to change the statement so that I get output regardless > of whether there's a match between prod.prodid and pa.prodid. IOW, if there's > a match between prod.prodid and pa.prodid, I want the output from both the > product table and the prod_alias table. if there's no match, I still want > the output from product table. Can I do this in one select statement?
This is what outer joins are used for. See http://developer.postgresql.org/docs/postgres/sql-select.html for the syntax and a very brief description of what they do. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
