Re: left join with multiple OR?

[Michael Ragsdale]

Shawn, thank you - that did the trick.

-Mike

At 10:18 AM 6/2/2004, [EMAIL PROTECTED] wrote:

Have you tried using the IN operator?

SELECT denewbs, dewrbtr, dekostl, desgtxt, deprojk,
        degeber, de_heid, acdesc, acfund
FROM (details INNER JOIN headers ON details.de_heid = headers.heid)
LEFT JOIN acctref ON acctref.acfund IN
(details.dekostl,details.deprojk,details.degeber)
WHERE headers.he_baid=38;

[........]

SELECT denewbs, dewrbtr, dekostl, desgtxt, deprojk,
        degeber, de_heid, acdesc, acfund
FROM (details INNER JOIN headers ON details.de_heid = headers.heid)
LEFT JOIN acctref ON ((details.dekostl = acctref.acfund) OR
                       (details.deprojk = acctref.acfund) OR
                       (details.degeber = acctref.acfund))
WHERE (((headers.he_baid)=38));

at a loss,
-Mike

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]