I have two select statements,

How to join queries? Mainly as the first diagram, the right to have a second select field! The union!

CodePudding user response:

Suppose you have two SQL

The select A.a, a. from hcg_pzh A

The select B.a, B.b from Form B

You can

The select A.a, a. B.a B.b from hcg_pzh A, Form B where A.a=B.a

CodePudding user response:

If you have any link two tables, you can use the 1st floor method and is ok,

CodePudding user response:

Well, it is ok