Have two tables A and B, A table including field 1, field 2, 3, field field 4, B table including field 2, field 3, field 5,
Now want to write A query, display A, B two tables field 2, field 3, field 4 and 5, how to implement?

CodePudding user response:

 select A. *, B. * 
From A, B 
Where Anderson, D=B.I D - associated conditions, according to the business you will decide 

CodePudding user response:

Looking for the introduction of several see
Look, single table query and two tables associated query

CodePudding user response:

The select A.c ol2, A.c ol3, A.c ol4, biggest ol5
From A
Inner join B
On A.c ol2=biggest ol2
And A.c ol3=biggest ol3