Skip to content
Advertisement

inserting two tables worth of data into one table where each has where condition

I have two tables that I would like to select rows from each having specific where clauses. I want to take that data and put it in one table. I have tried two methods but am getting errors on each of the methods. What is the solution? I can not use a left JOIN because there isnt anything to JOIN them on

CROSS JOIN ATTEMPT – fails with Two Where clauses

and then the nested method produces error – incorrect number of columns

Advertisement

Answer

In your cross join method, you have to use WHERE clause as follows:

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement