Quiz question

Arnone, Anthony aarnone@grey.com
Mon, 31 Jul 2000 13:22:19 -0400


I have a question that I cant seem to figure out. I am running ver 8.19 on
an HP3000 running MPE/iX. I have 2 subfiles, both include an Employee number
and a Product number. I linked these 2 files by employee number and I need
to only select records that dont exist on File2. For example:

 File 1 			File 2 
Empl	Product		Empl	Product 
3084	1		3084	1
3084	2		3094	2
3084	3
3084	4
3084	5 

I need to only select the last three records that dont exist on File 2.
Thank you for your help.

			            R/S
			Anthony Arnone
			212.546.1603
			Aarnone@grey.com


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.