I have a problem with the new joins. The following SELECT ;
Dissue.issue_id, ;
Dissue.os_id, ;
Dissue.actauth_id,;
Dissue.actallc_id, ;
Dissue.purp_id, ;
Dissue.cseries, ;
Dissue.amount,;
Dissue.comments, ;
Dactauth.fund_id, ;
Dactauth.counsel_id,;
dActAllc.Date as AllcDate ;
FROM dactallc ;
INNER JOIN Dissue;
INNER JOIN Dactauth ;
ON dactallc.actauth_id=Dactauth.actauth_id ;
ON Dissue.actallc_id=dactallc.actallc_id
does not bring in the correct fund_id and counsel_id while
SELECT ;
Dissue.issue_id, ;
Dissue.os_id, ;
Dissue.actauth_id,;
Dissue.actallc_id, ;
Dissue.purp_id, ;
Dissue.cseries, ;
Dissue.amount,;
Dissue.comments, ;
Dactauth.fund_id, ;
Dactauth.counsel_id,;
dActAllc.Date as AllcDate ;
FROM dactallc ,Dissue,Dactauth ;
WHERE dactallc.actauth_id=Dactauth.actauth_id ;
AND Dissue.actallc_id=dactallc.actallc_id
works correctly.
What am I doinf wrong???
Peter Cortiel