Hello All,

I am trying to write a SQL statement that will ALWAYS return a record (as shown in the last line below) as well as any additional records that fit the WHERE statement. I thought the UNION statement would do the trick but I can't get it to work.


myquery="SELECT name, dob, sex FROM contacts ;
WHERE contacts.id = current.id UNION ;
Select 'Billy', CTOD('02/02/1974'), 1 INTO CURSOR names"

Any ideas?

Thanks,
Greg