Mysql Right Join Query

[Dave_cha]

I'm just moved tables in a db I'm building from Access to MySql.
I have a query setup which comprises of two tables.

1) Employee Attendance Records
2) Employee Details

Table 1 uses an employee id field to tie back to an Employee details table.
I've created a Right Join from T1 to T2 to pull up the Employee name when displaying Attendance records.

While the tables were in Access I could add Attendance records using this query however now that I've moved the data to MySql the recordset cannot be added to. I could probably figure a work around in the Form VBA code for this particular query but this is going to give me a major headache when I start moving the tables from existing db's to MySql (which I have to do!!).

Does anyone know why MySql doesn't like the Right Join and is there any of solving this without having to adjust every similar query in every db?

Thanks Dave

 

[Dave_cha]

Thanks Pat.

I had another go this morning and managed to get it to work (with a join). I've been messing around with the tables and queries for the last day or so and obviously hit on something. Not sure exactly what I did to make it work but I'm not complaining.

Thanks again for your help.


Rgd's,

Dave