For Cartesian query the query string will be like
Code:
Select a.fieldA1, b.fielfdB1 FROM tblA a, tblB b
The query combines every row in tblA with every row in tblB.
For query using inner join the query string will be like
Code:
Select a.fieldA1, b.fielfdB1 FROM tblA a inner join tblB b ON a.AID = b.BID
The query returns values from record where join condition is true for both tables - i.e. when you have some AID value n table tblA, but don't have same value n tblB, then for this ID no info is returned.
For query using left join the query string will be like
Code:
Select a.fieldA1, b.fielfdB1 FROM tblA a left join tblB b ON a.AID = b.BID
The query returns results for every record in tblA combined with every record with matching ID in tblB, and with Null values for those tblB fields where no matching ID was found.
Someone here may explain what to do to create a left join query using wizard - I am quite illiterate about this!