Hello,

You definitely need to have a primary key to update but sometimes you may also need to add a timestamp field to the SQL table you are linked to. I...

OK if you are only doing a select why not use a SQL View to create the join you need and then link to the view instead of the two...

What is the type of query... is it just a select or is it an update?

Thanks,

I think you just need to do the first part of what Wayne suggested:

LEFT JOIN test_bank ON (customers.username = test_bank.username

AND products.ccode = test_bank.courseid)

This should fix your problem....