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
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
- 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
/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
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
5 matches
Mail list logo