MySQL Forums
Forum List  »  Newbie

Re: Query completion
Posted by: Peter Brawley
Date: January 29, 2018 01:27PM

You proved `param` is unique in each table? Run an exclusion join to see what's going on eg ....

select n.id,n.value,t.id,t.value
from new_table n
left join table1 t using(id,value)
where t.id is null;

Options: ReplyQuote


Subject
Written By
Posted
January 29, 2018 11:29AM
January 29, 2018 12:01PM
January 29, 2018 12:17PM
Re: Query completion
January 29, 2018 01:27PM
January 29, 2018 02:26PM
January 29, 2018 02:49PM
January 29, 2018 03:17PM
January 29, 2018 03:58PM
January 30, 2018 02:25AM
January 30, 2018 10:20AM
January 30, 2018 02:36AM
January 30, 2018 02:42AM


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.