If you do: Use (ADDBS(this.cDataPath)+this.cClaimsTable) in 0 alias x1 Use (ADDBS(this.cDataPath)+this.cDischargeTable) in 0 alias x2
Select provnum from x1 Union select provnum from x2 Into Cursor curTemp ... is that any quicker? How big are these tables? -- Alan Bourke alanpbourke (at) fastmail (dot) fm _______________________________________________ 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/1345127944.25832.140661115652869.44611...@webmail.messagingengine.com ** 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.
