Existing A, B two tables
Two table data structure and data of the same
Want to check out A table and table B in the same field
Field in a different data, how to write a SQL statement?

CodePudding user response:

Since field A different data and that data, it is not the same,

The select tablea. A, tableb. From a tablea, tableb
Where tablea a!=tableb. A

CodePudding user response:

Select * from (select * from a left join b on Amy polumbo ar=p. ar) where k p. ar is null

CodePudding user response:

Frontal write wrong you will have to b take alias field, and then in the end, where k. alias. Is null