I want to extract patients with an specific Diagnosis code as operation diagnosis (in this case Q41) Diagnoses of the patient are in table nddiagnosen (base_id is the key-field) In table ndfall2 are stored the base_id's of diagnoses for Surgery (maximal 5 ) In the SQL-Query SELECT DISTINCT ndFall0.fall_id,ndFall0.pat_id ; FROM ndFall0 ; JOIN ndpat0 ON ndPat0.pat_id=ndFall0.pat_id ; JOIN ndfall1 ON ndfall1.fall_id=Ndfall0.fall_id ; INTO CURSOR (tmp_dat) READWRITE ; WHERE ((EXISTS (SELECT * FROM nddiagnosen dg WHERE dg.fall_id=ndFall0.fall_id and dg.loesch=0 and ; dg.base_id IN (NdFall1.opdgn1,NdFall1.opdgn2,NdFall1.opdgn3,NdFall1.opdgn4,NdFall1.opdgn5) AND (dg.dgnnr1='Q41' OR dg.dgnnr2='Q41')))) I get the orror 1801 (SQL: Error correlating fields.)
The problem is in the part dg.base_id IN (NdFall1.opdgn1,NdFall1.opdgn2,NdFall1.opdgn3,NdFall1.opdgn4,NdFall1.opdgn5) any sugestions?? Joerg Arand MD assistant medical director Neonatology Children's Hospital University Tuebingen Calwer Str. 7 D-72076 Tuebingen Tel.+49-(0)7071-2982211 Tel.+49-(0)7071-2980895 (office) E-mail:Joerg.Arand(AT)med.uni-tuebingen.de --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
