Query to get data from two tablesI need to get records from two tables which don't have any criteria as matching i.e pkey and fkey matching etc.The database used is ms access.Below is the query generated by query wizard but is returns records when number of rows in both the table are equal.
SELECT Table1.*, Table2.*FROM Table1, Table2;
i want to get all the available records from table1 and table2.
Thanks in advance