Quiz question

[Mike.Lamers@phs.com]

Is the index on file2 built only on empl?  If you build a compound index on
empl, prod, then you could use:

access *file1 link empl, prod to empl, prod of file2 optional
select if not record file2 exists

I think this would give the same result as Dave has suggested, but would
have a smaller initial report matrix.  If your subfiles are very large, that
could make a difference in performance.

Mike
> -----Original Message-----
> From:	Knox, Dave  (Dallas, TX) [SMTP:knoxda01@unisourcelink.com]
> Sent:	Monday, July 31, 2000 11:37 AM
> To:	'POWERH-L@LISTS.SWAU.EDU'; 'Arnone, Anthony'
> Subject:	RE: Quiz question
> 
> 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.
> 


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