I am trying to set up a recordset and I am using the Advanced RecordSet tool.
I have no difficulty with simple Select statements.
I cannot get any SQl commands that include an Inner Join to work. I have carefully tested my syntax using MySql Query Browser.
Has anyone used inner joins with this tool?