SELECT (slightly) FROM A table ON A LEFT JOIN table B B (a. name LIKE '*' & amp; B. name & amp; '*') AND (=b. a. amount unpaid)

For example, A table with the name "zhang", B in the table has A name "zhang SAN/li si", but the query results in threes no table B "zhang SAN/li si" data,

CodePudding user response:

Write the inverse connection conditions, should be b. name to LIKEa. Name, change the following


SELECT (slightly) FROM A table ON A LEFT JOIN table B B ( b. name LIKE '*' & amp; A. name & amp; The '*' ) AND unpaid) (a. amount=b.

CodePudding user response:

Agree with the second floor