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
May all your weeds be wildflowers