a.rhrssid = b.sid))
> where a.rhrqsid = 101 or a.rhrssid = 101
>
> Thanks,
> ViSolve DB Team
>
>
>
> - Original Message -
> From: "KMiller" <[EMAIL PROTECTED]>
> To:
> Sent: Tuesday, February 06, 2007 8:37 AM
> Subject: outer join quest
This query isn't what I want...
select a.rhrqid,a.rhrqsid,a.rhrssid,b.sid,b.rlsid
from rqhistory a left join relay b
on a.rhrqsid = 101 or a.rhrssid = 101
and (a.rhrqid = b.rqid and (a.rhrqsid = b.rlsid or a.rhrqsid = b.sid or
a.rhrssid = b.rlsid or a.rhrssid = b.sid))
because it returns all row
