On 6/4/2013 11:23 AM, Jean MAURICE wrote:
Le 30/05/2013 23:51, Tracy Pearson a écrit :
In VFP, you pull them in to separate cursors, then UNION them together.
In my humble opinion, UNION will only give unique lines. If you want all
the lines (so with all duplicate lines) you must write UNION ALL

The Foxil


But Jean Maurice, I didn't want duplicates...just the unique set of rows (as the subject said)...hence his UNION suggestion.

--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.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.

Reply via email to