sql - MYSQL: Two Table SELECT without common values -


I need a query to select on Table 1 and Table 2. I want them to appear as a normal result, but there is no value from Table 1 without any connection that matches any value from Table 2. So if the result is from Table 1, then the value table 1.a, table1.b, Table1.c, if it comes from Table 2, then Table 2D, Table 2 E, Table 2 With FA, B, C-value blank.

  SELECT * table1, table2  

... does not help me because it always creates a connection, as a result of Table 1 and Table 2 Adds results.

Is it simple, difficult or impossible?

You must use the same aliases for the equivalent columns of both tables, such as:

  (choose one as FIRST_COL from table 1) union (select FIRST_COL as table 2)  

Comments

Popular posts from this blog

asp.net - Javascript/DOM Why is does my form not support submit()? -

sockets - Delphi: TTcpServer, connection reset when reading -

javascript - Classic ASP "ExecuteGlobal" statement acting differently on two servers -