MySQL Forums
Forum List  »  Views

Re: (reverse) join
Posted by: Peter Brawley
Date: March 12, 2014 01:11PM

> there are a multiple key to the multiple tables.

Works just as well with multiple keys, eg ...

select ...
from a
left join b on a.m=b.n and a.x=b.y
left join c on b.q=c.r and b.s=c.t
where c.r is null;

Options: ReplyQuote


Subject
Views
Written By
Posted
5728
March 12, 2014 08:53AM
1760
March 12, 2014 09:42AM
1759
March 12, 2014 09:51AM
1817
March 12, 2014 11:48AM
Re: (reverse) join
1873
March 12, 2014 01:11PM
2027
March 13, 2014 03:23AM
1750
March 13, 2014 10:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.