Table An is associated with Table B, querying data that is present in Table A but not in Table B.

Table A

< table > < thead > < tr > < th align= "left" > id < / th > < th align= "left" > column1 < / th > < th align= "left" > column2 < / th > < / tr > < / thead > < tbody > < tr > < td align= "left" > 1 < / td > < td align= "left" > a < / td > < td align= "left" > A1 < / td > < / tr > < tr > < td align= "left" > 2 < / td > < td align= "left" > a < / td > < td align= "left" > a2 < / td > < / tr > < tr > < td align= "left" > 3 < / td > < td align= "left" > a < / td > < td align= "left" > A3 < / td > < / tr > < tr > < td align= "left" > 4 < / td > < td align= "left" > b < / td > < td align= "left" > b1 < / td > < / tr > < tr > < td align= "left" > 5 < / td > < td align= "left" > b < / td > < td align= "left" > b2 < / td > < / tr > < tr > < td align= "left" > 6 < / td > < td align= "left" > b < / td > < td align= "left" > b3 < / td > < / tr > < tr > < td align= "left" > 7 < / td > < td align= "left" > c < / td > < td align= "left" > C1 < / td > < / tr > < / tbody > < / table >

Table B

< table > < thead > < tr > < th align= "left" > id < / th > < th align= "left" > column1 < / th > < th align= "left" > column3 < / th > < / tr > < / thead > < tbody > < tr > < td align= "left" > 1 < / td > < td align= "left" > a < / td > < td align= "left" > A1 < / td > < / tr > < tr > < td align= "left" > 2 < / td > < td align= "left" > a < / td > < td align= "left" > a2 < / td > < / tr > < tr > < td align= "left" > 3 < / td > < td align= "left" > b < / td > < td align= "left" > b1 < / td > < / tr > < tr > < td align= "left" > 4 < / td > < td align= "left" > b < / td > < td align= "left" > b2 < / td > < / tr > < / tbody > < / table >

Table An and Table B are associated through the column1 field. The filter condition is that the value of column2 in Table A does not have a corresponding value in Table B"s column3 . According to the data in the table above, the result should be:

< table > < thead > < tr > < th align= "left" > id < / th > < th align= "left" > column1 < / th > < th align= "left" > column2 < / th > < / tr > < / thead > < tbody > < tr > < td align= "left" > 3 < / td > < td align= "left" > a < / td > < td align= "left" > A3 < / td > < / tr > < tr > < td align= "left" > 6 < / td > < td align= "left" > b < / td > < td align= "left" > b3 < / td > < / tr > < tr > < td align= "left" > 7 < / td > < td align= "left" > c < / td > < td align= "left" > C1 < / td > < / tr > < / tbody > < / table >
Mysql
Dec.24,2021 
select * from a where not exists 
(select 1 from b where a.column1=b.column1 and a.column2=b.column2;

I don't understand. Why isn't id=4 the data you want? 

select * from tableA where id not in (select a.id from tableA a,tableB b where a.column1=b.column1 and a.column2=b.column3)
< hr > 
select * from(
select * from tableA
union all
select a.* from tableA a,tableB b where a.column1=b.column1 and a.column2=b.column3
)temp group by id having count(id)=1

both of the above methods can be used

Previous: The problem of taking the value of es6 object

Next: What is the difference between os.exit () runtime.Goexit () return in golang

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
© 2021 CodesHelper
Advertising Contact us About us
Menu