Re: multiple OUTER joins in SQL?

2002-09-21 Thread Gyrus
Thanks Brian Dina, I'm actually getting there with this confounded query! ;-) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available

Re: multiple OUTER joins in SQL?

2002-09-20 Thread Dina Hess
Try this: SELECT c.itemID, c.title, c.ownerID, c.type, i.subject, i.intDate, r.rvwType FROM content c LEFT JOIN interviews i ON c.itemID = i.itemID

Re: multiple OUTER joins in SQL?

2002-09-20 Thread Gyrus
- Original Message - From: Dina Hess [EMAIL PROTECTED] Try this: SELECT c.itemID, c.title, c.ownerID, c.type, i.subject, i.intDate, r.rvwType FROM

Re: multiple OUTER joins in SQL?

2002-09-20 Thread Dina Hess
/paste. - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 20, 2002 1:43 PM Subject: Re: multiple OUTER joins in SQL? - Original Message - From: Dina Hess [EMAIL PROTECTED] Try this: SELECT c.itemID

RE: multiple OUTER joins in SQL?

2002-09-20 Thread Bryan Love
Subject: Re: multiple OUTER joins in SQL? - Original Message - From: Dina Hess [EMAIL PROTECTED] Try this: SELECT c.itemID, c.title, c.ownerID, c.type, i.subject, i.intDate