https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/4487.aspxFri, 29 Oct 2004 09:24:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4487sosan0https://www.infopathdev.com:443/forums/thread/4487.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4487I 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).<br /><br />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.<br /><br />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:<br /><br />Select * from table1, table2 where table1.pk=table2.pk<br /><br />i want only the records where table1.pk=table2.pk<br /><br />Help me please...i've to write the sql code for my query? <br /><br />sorry for my bad english<br /><br /><br /><br />