Re: SQL Count vs. Select 1

[CRPence <CRPbottle@xxxxxxxxx>]

THarteau wrote:
> I am writing a purge program. I need to check if the item number 
> exists in 12 different files. I was going to use count to see if the
> item number is in each file, but was wondering if 'Select 1'  and
> check for an error would be a better approach.  I thought I saw
> something like this awhile ago, but cannot find it in the archives.

  Probably a[n example of] WHERE EXISTS subquery is of interest.  FWiW, 
an SQL question by itself, is not an RPG topic.

Regards, Chuck