S
Stefan Drissen
Guest
Klaus, your query will probably generate too many records. You probably need outer-join: DEFINE TEMP-TABLE tt1 FIELD cc AS CHAR FIELD ii AS INT . DEFINE TEMP-TABLE tt2 FIELD cc AS CHAR FIELD ii AS INT . DEFINE TEMP-TABLE tt3 FIELD cc AS CHAR FIELD ii AS INT . CREATE tt1. tt1.cc = "A". CREATE tt2. tt2.cc = "A". CREATE tt3. tt3.cc = "A". CREATE tt3. ASSIGN tt3.cc = "A" tt3.ii = 1. CREATE tt1. tt1.cc = "B". CREATE tt3. tt3.cc = "B". DEFINE QUERY qq FOR tt1, tt2, tt3. OPEN QUERY qq FOR EACH tt1, EACH tt2 OUTER-JOIN WHERE tt2.cc = tt1.cc, EACH tt3 OUTER-JOIN WHERE tt3.cc = tt1.cc . GET FIRST qq. DO WHILE AVAILABLE tt1: MESSAGE tt1.cc tt1.ii SKIP tt2.cc tt2.ii SKIP tt3.cc tt3.ii VIEW-AS ALERT-BOX. GET NEXT qq. END.
Continue reading...
Continue reading...