>>fld1qry1 fld2qry1 >> data1 data1 >> data2 data1 >>>>
>>fld1qry2 fld2qry2 >> data1 data1 >> data2 data2 >> data3 data3 >>>>
>>fld1qry1 fld2qry1 fld1qyr2 fld2qry2 >> data1 data1 data1 data1 >> data2 data2 data2 data2 >> data3 data3 >>Just of the top based on your response:
SELECT *, RECNO() as RecID ; FROM qyr1 ; INTO CURSOR qry11 SELECT *, RECNO() as RecID ; FROM qyr2 ; INTO CURSOR qry22 SELECT * ; FROM qyr11, qry22 ; WHERE qry11.recid = qry22.recid ; UNION ALL ; SELECT * ; FROM qyr11, qry22 ; WHERE qry11.recid # qry22.recid ; INTO CURSOR whateverPlease comment. Thanks
* Add record number as a record Id to both queries >* to match them later >Select fld1qry1, fld2qry1, Recno() as RecId ; > FROM Query1 ; > INTO CURSOR crsQ1 >Select fld1qry2, fld2qry2, Recno() as RecId ; > FROM Query2 ; > INTO CURSOR crsQ2 >* Select all records with matching Id's (recno) >* and add unmatched records from the second query >* Assumes that size of fld1qry1 and fld2qry1 is 20 chars >SELECT fld1qry1, fld2qry1, fld1qry2, fld2qry2 ; > FROM crsQ1, crsQ2 ; > WHERE crsQ1.RecId = crsQ2.RecId ; >UNION ; >SELECT Space(20), Space(20), fld1qry2, fld2qry2 ; > FROM crsQ2 ; > WHERE crsQ2.RecId NOT In ( ; > Select RecId FROM crsQ1) ; >INTO CURSOR crsrep>>Hi all
>>fld1qry1 fld2qry1 >> data data >> data data >>>>
>>fld1qry2 fld2qry2 >> data data >> data data >> data data >>>>
>>fld1qry1 fld2qry1 fld1qyr2 fld2qry2 >> data data data data >> data data data data >> data data >> data data >> data data >>>>