Using INNER JOIN to link related tables
Has anyone managed to get a query using INNER JOIN to work correctly? Every time I introduce a field from another table into a query, I get an SQL parsing error. I am using (I think) pretty standard dialect SQL:
tablename."
Fieldname" and
SELECT t1.f1, t1.f2, t1.f3, t1.f4, t2.f1, t2.f2 FROM t1 INNER JOIN t2 ON t1.f1=t2.f1;< br/>< br/>
I have managed to create a join using the following:
SELECT Staff."FirstName",Staff."Surname",Role."Position"
FROM Staff,Role
WHERE Staff."RoleID"=Role."PositionID";
...but i would rather use INNER JOIN for more complex linking.