Hi

Could someone please explain to me why

select masthead.*, mastdetl.* ;
FROM masthead INNER JOIN mastdetl;
ON Masthead.id = Mastdetl.id ;
WHERE !masthead.exported ;
INTO cursor headdetl

returns 7 records (all detail links found)

and

select masthead.*, staff.* ;
FROM masthead INNER JOIN staff ;
ON Masthead.staff = Staff.s_code ;
WHERE !masthead.exported ;
INTO cursor headstaff

returns 3 records (all headers have a staff record)

yet

select masthead.*, mastdetl.*, staff.* ;
FROM masthead INNER JOIN mastdetl;
INNER JOIN staff ;
ON Masthead.staff = Staff.s_code ;
ON Masthead.id = Mastdetl.id ;
WHERE !masthead.exported ;
INTO cursor headstaffdetl

returns nothing.

even stranger is the fact that

select headdetl.*, staff.* ;
FROM headdetl INNER JOIN staff ;
ON headdetl.staff = Staff.s_code ;
WHERE !headdetl.exported ;
INTO cursor headdetlstaff

returns my 7 records.

What gives???

An extremely confused
Geoff Scott