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