Hi,
I am trying to join two tables to produce a report. A Todo table has two fileds that reference the user table. I can successfully join on one field.
SELECT Users.User, ToDo.*
FROM todo INNER JOIN Users ON (Users.UserID = ToDo.Closedby)
But trying to join on both fields i have problems. I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.