You can use Union here. Like:

Select DIST lastname,firstname,isblock,blockslot,schdatedist from Meetings where SCHDATE=(given date);
UNION;
Select dist blocks.lastname, blocks.firstname, isblock, blocks.blockslot, blocks.schdatedist from blocks, meetings where blocks.SCHDATE=(given date) and;
blocks.firstname+blocks.lastname==meetings.firstname+meetings.lastname

The result will not contain records which are in blocks only.
All related fields must have the very same structure (blocks.firstname/meetings.firstname, etc..)

Good luck

>Meetings.dbf
>
>

>Meetings.dbf
>
>lastname,firstname,isblock,blockslot,schdate
>
>blocks.dbf
>
>lastname,firstname,blockslot,schdate
>
>

>
>In the first table individual patients are scheduled or a block is defined. If it is a block than isblock=.t..
>
>I need a query that returns a cursor of dist cases for a given date from both tables.
>

>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
>
>

>
>Any help greatly appreciated
>
>Kirk