query question - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

query question

Last post 10-29-2004 02:24 AM by sosan. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 10-29-2004 02:24 AM

    • sosan
    • Not Ranked
    • Joined on 10-28-2004
    • Italy
    • Posts 4

    query question

    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

Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.