good catch. I've noticed that with PHP and MySQL the ID columns have to be unique whereas in ASP I can have multiple ID columns in a JOIN and they appear in the bindings panel as tablename.ID.
This is an older page, from before I figured that out.
I'll play around with the query and see if I can get the correct unique ID.
Thank you for your insight.