Oracle of (+) how to use grammar in MySQL, consult a great god

CodePudding user response:

What you said should be left to join and right join the plus sign

CodePudding user response:

The + is unique to the oracle, to deal with the outside connection, is left to join and right join, but with the standard SQL syntax, + is on the condition of less data on the side,

CodePudding user response:

reference 1st floor ZJHZ_ leaf response:

you said should be left to join and right the plus sign which join

Well, mysql with left join and right in the join

CodePudding user response:

refer to the second floor minsic78 response:

this + is unique to the oracle, to deal with the outside connection, is left to join and right join, but with the standard SQL syntax, + is less data on one side, on the condition of

Ok, these! ... !!!!!!!!!!!!!!!!!!!

CodePudding user response:

Plus at least antiques are more than a decade ago, now should be all JOIN,
Helpful hints in MYSQL under FULL JOIN there is a problem,