Make Table returns multible records

fredp

New member
Local time
Yesterday, 22:16
Joined
May 6, 2013
Messages
5
Hi,
I have two tables with compatible data. Table 1 has 23 records and table 2 has 5 records. I am trying to make a "make Table". But instead of a table with a combined 28 results, I get 115.
I was working on this with my instructor the other day. I know it was an easy fix, but I guess my notes are not very good.
 
You get 115 (Cartesian product) because you don't have a join between the tables. To get 28 you may have used a UNION query.
 

Users who are viewing this thread

Back
Top Bottom