Thanks for all replies. I now have an idea for the morning Thanks all Al -----Original Message----- From: Frank Cazabon Sent: Tuesday, March 13, 2012 6:13 PM To: [email protected] Subject: Re: relations VFP9 SP2
Hi Allen, if doing a select you need to "relate" the two tables by the pointer fields. Something like : Select ; table1.field1 as f1,; table1.field2 as f2,; table2.field3 as f3,; table2.field4 as f4; from table1 inner join table2 on table1.pointer = table2.pointer; into cursor mycursor. Frank. Frank Cazabon _______________________________________________ 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/26568C03D77A422DB4D0F607D14238D2@gslredacer ** 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.
