I have two tables that I'm trying to join and retrieve data from. table1 will always have data in it but table2 may not.
If table2 is empty and I perform something like this:
SELECT * FROM table1, table2;
I get no results. Can someone explain why and if there is a solution? All fields in both tables have a NOT NULL condition. I suspect this is a big reason for the problem. Thanks.
