hmc
November 28th, 2006, 10:17 AM
Hi, i have a problem with a sql query in MsAccess.
I have the following tables: Person, Function and a link table PersonFunction.
Each Person can have more than one function, but it is enough to have only one function in the result.
I want to select all persons and their functionname in a result. The problem is that not all persons have a function, so when i use where clause in the query these persons are not selected. I want all persons to be in the result even if they do not have a function. I tried LEFT OUTER JOIN in Access but i get errors. Anyone knows how to query for this result? Thanks.
I have the following tables: Person, Function and a link table PersonFunction.
Each Person can have more than one function, but it is enough to have only one function in the result.
I want to select all persons and their functionname in a result. The problem is that not all persons have a function, so when i use where clause in the query these persons are not selected. I want all persons to be in the result even if they do not have a function. I tried LEFT OUTER JOIN in Access but i get errors. Anyone knows how to query for this result? Thanks.