>>Roxy,
>>
>>I think you need to add aliases to that second query and add a condition, like this:
>>
>>
>>SELECT * FROM ALPHA_X A WHERE NOT EXISTS( ;
>> SELECT * FROM ALPHA_X B WHERE A.Somefield = B.Somefield AND B.stype="WL " AND B.progtype="NP") ;
>> INTO CURSOR ALPHATMP
>>
>>I think that ought to do it.
>>
>I tried playing around with something similar to that, will try again if I get the chance. For now I just changed code to reflect Fast Eddies response.
>
The actual query I used to test this went something like:
SELECT * FROM Stds A WHERE EXISTS;
(SELECT * FROM Stds B WHERE A.Style = B.Style AND BETWEEN(B.Style, '50000', '60000'));
INTO CURSOR Foo
There were 4 records in the Stds table that fell between those two numbers and that's how many the query returned. That A/B comparison stuff may be overkill.
>>How come no new picture of you from DevCon (with hat, of course)?
>>
>Actually, I did have one taken when I was stuck at Chicago airport with me wearing my hat backwards and working on DevCon article. But I didnt put it up on the webpage with my other pics because I look really hungover, and I didnt want boss to question the fact I missed my plane out of SD. :D)
O'Hare or Midway. O'Hare I hope. Being stuck at Midway wouldn't be fun. I'm originally from there.
Will you post or send me the address of your page so I can take a look. I've been so busy that I forgot to drop on by.
George
George
Ubi caritas et amor, deus ibi est