Syntax question

[John Taylor <d_low22003@xxxxxxxxx>]

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?
 
 Thanks,
 
 Don

---

Ring'em or ping'em. Make  PC-to-phone calls as low as 1¢/min with Yahoo! Messenger with Voice.