The syntax should be:
SELECT * ;
FROM table1 INNER JOIN table2 ON table1.key=table2.key ;
INNER JOIN table3 ON table1.key=table3.key
You have the INNER JOIN and ON statements grouped together.
>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???
Eric Shaneson
Cutting Edge Consulting