Re: [GENERAL] Syntax question

2006-05-26 Thread David Fetter
On Fri, May 26, 2006 at 09:09:25AM -0700, John Taylor 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,

Re: [GENERAL] Syntax question

2006-05-26 Thread A. Kretschmer
am 26.05.2006, um 9:09:25 -0700 mailte John Taylor folgendes: > 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 possibl

Re: [GENERAL] Syntax question

2006-05-26 Thread Bruno Wolff III
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;

[GENERAL] Syntax question

2006-05-26 Thread John Taylor
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