JET SQL

Got home today. 3276 emails in my Inbox ( and that does not include the hundreds I deleted on the server using my web mail interface ). By the time I set up some more Outlook Rules and deleted the random spam I had 75 legitimate emails to answer. And people wonder why IT project schedules often slip.

I have another question to pose to the community ( hopefully there are some JET SQL experts among you ). I am trying to convert some SQL queries which have multiple joins to Access format and so far have not been successful. Here is an example:

GetUserDefinedRows

select UserDefinedRows.UserDefinedRowId,
UserDefinedFields.FieldTitle,
UserDefinedData.FieldValue
from UserDefinedRows
inner join UserDefinedFields on UserDefinedData.UserDefinedFieldId = UserDefinedFields.UserDefinedFieldId
left outer join UserDefinedData on UserDefinedRows.UserDefinedRowId = UserDefinedData.UserDefinedRowId
where UserDefinedRows.ModuleId = @ModuleId

if I try to execute this query in Access I get a "syntax error in join". Send your ideas to shaunw1@shaw.ca ( and I wonder why I get so much spam! )