Quiz question

[Knox, Dave (Dallas, TX)]

access *file1 link to empl of *file2 optional

select file2 if prod of file1 = prod of file2

select if not record file2 exists

hth

Regards
Dave

> ----------
> From: 	Arnone, Anthony[SMTP:aarnone@grey.com]
> Sent: 	Monday, July 31, 2000 12:22 PM
> To: 	'POWERH-L@LISTS.SWAU.EDU'
> Subject: 	Quiz question
> 
> 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.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.