Skip to Content
0
Former Member
Jul 18, 2008 at 07:57 PM

How to create a query with inner join in SQ01?

2898 Views

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