I have a sqlserver db and a form in infopath with some fileds from a primary table and others from a secondary table. there is a relation from the tables (pk).
If I choose a criteria in the form from primary table and submit the query ut shows only the records that respond to my query.
If i choose a criteria from the secondary table it shows all records from the primary with an empty row in the records that doesn't respond to my query. How can i have a result like this:
Select * from table1, table2 where table1.pk=table2.pk
i want only the records where table1.pk=table2.pk
Help me please...i've to write the sql code for my query?
sorry for my bad english