SELECT * ; FROM Meetings ; WHERE NOT isblock ; UNION ; SELECT lastname,firstname, .F. As isblock, blockslot,schdate; FROM blocks ; INTO CURSOR mycursorI have no idea what is relation between Meetings and blocks tables that's why this select doesn't take it in account.
>Meetings.dbf > >lastname,firstname,isblock,blockslot,schdate > >blocks.dbf > >lastname,firstname,blockslot,schdate > >>
>Example: > >Meetings.dbf with 2 records >LASTNAME FIRSTNAME ISBLOCK BLOCKSLOT SCHDATE >======================================================= >KELLY KIRK .F. 1234 10/07/2001 >BLOCK BLOCK .T. 1235 10/07/2001 > >Blocks.dbf with 1 record > >LASTNAME FIRSTNAME ISBLOCK BLOCKSLOT SCHDATE >======================================================= >KELLY ROGER .F. 1235 10/07/2001 > > >Desired Results: > >LASTNAME FIRSTNAME ISBLOCK BLOCKSLOT SCHDATE >======================================================= >KELLY KIRK .F. 1234 10/07/2001 >KELLY ROGER .F. 1235 10/07/2001 > >>