MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Limit OR Join to 1 row
Posted by: John Noble
Date: July 28, 2020 03:51PM

Hi Peter,

Did you mean to say XOR and not OR?

OR WILL find a match from both sides of the join which is what I don't want.

Will XOR check the first part of the join and if it finds a result won't check the 2nd part of the join?

If so then that is what I want.

John

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Limit OR Join to 1 row
John Noble
July 28, 2020 06:13AM
Re: Limit OR Join to 1 row
Peter Brawley
July 28, 2020 09:33AM
Re: Limit OR Join to 1 row
John Noble
July 28, 2020 03:51PM
Re: Limit OR Join to 1 row
Peter Brawley
July 28, 2020 08:57PM


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.