sql - Error in query, two select statements with left join? -


I have two selected statements: 

  a: a.1, a.2 Select from A1 Table 1A: Select b.1, b.2, b.3 from table1b

Now can I join these two statements?

I tried the following method and found the error: 

  select (leave table A, select a, a, a, a.3) Select b.1, b.2, b3 to table 1b) bb aa.a.1 = bbb.1; To join your left side, you must go to  ON / WHERE

/ code> section: Choose 

  (select a1, a.2, a.3 from table 1a) left AA (selection b.1, b.2, b.3 from table 1) B) BA Aa.a.1 = bb.b.1,

should be in the format: 

  SELECT * (SELECT a. 1, A2, A 1 to 1 Table 1a) AE Left Zone (SELECT b.1, b.2, b.3 to Table 2b) A1 = B.1WHE on BB ...
< P> For more clarification, please see this picture:

Enter image details here

As it stands at present, it is very difficult to know what your requirements are, that you want to return, but I will not allow this image to be Show the syntax for each of the visually impaired


Comments

Post a Comment