>I modified your suggestion slightly, trying the following:
>
>
SELECT userfile.usernumber, appfile.processid ;
> FROM userfile ;
> FULL join appfile ON .t. ;
> LEFT JOIN accessfile ;
> ON userfile.usernumber = accessfile.usernumber ;
> AND appfile.processid = accessfile.processid ;
> WHERE ISNULL(accessfile.processid) ;
> INTO CURSOR NewRecs
>
>Now I get error 1581, field ProcessID does not accept null values. Again, runtime only, not in development. (Actually, I'd be much happier if the errors happened in development as well, since it'd be a lot easier to try different combinations).
I am not sure if this SELECT will works, because I don't know how the SELECT JOINs the tables.
I am too tired now to uncover some secrets of SELECTs, but if you send me these 3 tables with a simple date tomorow I'll try to reach what you want, if you doesn't do it already.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.