Can someone point me the direction? I got 2 table named "Title" and "Detail"
Title File -DocNo C(10) -Date D(8) -PrintMark L(1) Detail -DocNo C(10) -StkID C(5) -Qty N(5) -Amt N(10,2) e.g. Title File contains D001 D002 D003 D004 D005 Detail file contains D001 S1 1 2.00 D001 S2 1 1.00 D003 S5 1 5.00 D005 S1 1 2.00 Now, my question is when user selected only "D001" and "D005" by enter "Y" to PrintMark, how I'm going to use SQL command to make a cursor with Title+detail? I have tried use the following sql command, but the result is wrong. select DocNo,StkID,Qty,Amt from Detail where Detail.DocNo $ Title.DocNo and Title.PrintMark into cursor TransRpt Thanks foxes wtc _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
