Hi
I got the following message:
SQL: Error correlating fields (Error 1801)
>Hi Chaim,
>
>>Hi
>>Program for laboratory
>>
>>I have a table with two fields: personid and disease.
>>This table contain only the person that diagnosed sick for one disease or more and the diagnosed diseases (Person can be sick for more than 1 disease).
>>
>>I want to find persons that sick for same disease of the next/previous personid (if they tested togother maybe the tubes mixed).
>>In the following examle I will get the persons 931694/5 sicks for same disease.
>>
>>CREATE CURSOR sicks (personid i, disease c(15))
>>INSERT INTO sicks VALUES (883554,'rabies')
>>INSERT INTO sicks VALUES (128748,'inflammation')
>>INSERT INTO sicks VALUES (123654,'angina')
>>INSERT INTO sicks VALUES (146528,'angina')
>>INSERT INTO sicks VALUES (918457,'rabies')
>>INSERT INTO sicks VALUES (585846,'rabies')
>>INSERT INTO sicks VALUES (931694,'inflammation')
>>INSERT INTO sicks VALUES (123654,'inflammation')
>>INSERT INTO sicks VALUES (325896,'angina')
>>INSERT INTO sicks VALUES (513258,'rabies')
>>INSERT INTO sicks VALUES (652845,'drill')
>>INSERT INTO sicks VALUES (254636,'angina')
>>INSERT INTO sicks VALUES (842169,'angina')
>>INSERT INTO sicks VALUES (195499,'rabies')
>>INSERT INTO sicks VALUES (585842,'rabies')
>>INSERT INTO sicks VALUES (128788,'drill')
>>INSERT INTO sicks VALUES (124558,'angina')
>>INSERT INTO sicks VALUES (931695,'inflammation')
>>
>>PS
>>If it's possible, I prefer to get it by count group (2sequential persons for same disease,3,4..)
>>
>>Big thank's
>>Try:
>
>SELECT * FROM sicks;
> WHERE exist (SELECT personID FROM sicks auxSicks;
> WHERE auxSicks.personID - 1 = sicks.personID;
> AND auxSicks.disease = sicks.disease;
> );
> OR exist (SELECT personID FROM sicks auxSicks;
> WHERE auxSicks.personID + 1 = sicks.personID;
> AND auxSicks.disease = sicks.disease;
> );
> INTO CURSOR crsSicks
>
>BROWSE NORMAL
>
>I hope this helps you.
Thank you
Chaim
