MySQL Forums
Forum List  »  Views

Re: (reverse) join
Posted by: Peter Brawley
Date: March 12, 2014 09:42AM

Read about exclusion joins. Assuming idSE is the serverog PK, and that the other tables have columns corresponding to that key ...

select a.whatever ...
from (
  select ...
) a
left join serverog s on ... a.idSE=s.idSE
where s.idSE is null;

Options: ReplyQuote


Subject
Views
Written By
Posted
5727
March 12, 2014 08:53AM
Re: (reverse) join
1759
March 12, 2014 09:42AM
1758
March 12, 2014 09:51AM
1816
March 12, 2014 11:48AM
1873
March 12, 2014 01:11PM
2024
March 13, 2014 03:23AM
1748
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.