Linking question

Pat Shugart ShugartP@trinity-health.org
Mon, 19 Feb 2001 10:22:09 -0500


Give this a shot:

:QTP

ACCESS SET A &
  LINK TO SET B OPTIONAL

SELECT IF NOT RECORD B EXISTS

SUBFILE C INCLUDES A

GO

______________________________________________
互户互户互户互户互户互
                                              
Pat Shugart
Trinity Information Services
Farmington Hills, MI 48331
248.489.6123
248.488.9195 (fax)

>>> <jlkeepers@mmm.com> 02/19/01 10:10AM >>>


Morning all (at least at this part of the world!),

I am wondering what is the best way to link two data sets together so that the
output file contains records from SET A that are NOT in SET B.  Any ideas would
be appreciated.

Sincerely,
Jeff Keepers


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu 
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu 
This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.