Hello All:
I am creating a query that joins 2 z tables to display some information. For one record in table 1 there are multiple records in table b (1 to many relationship). My query displays all the details from table 2 for one record in table 1 and I want to avoid this. I just want to show the record only once. In sq01 I have the option to create only left joins but no inner joins. Could someone please give me any information?
Thanks.
Mithun