This content has been marked as final. Show 4 replies
You are doing an "inner join" using the old syntax by including the tables in the FROM and "joining" them in the WHERE. What results are you getting that are different than what you expect?
I'm not getting any results. Just that I'm getting an error... that's it.
What's the error message? By the way, since you are requesting so many fields, a good format for debugging is:
It makes it easy to see if you are missing any commas.
If you have no results then your WHERE clause is to blame, and you have no case where the same retireid exists in all three tables. Are you sure that you want to be doing an INNER JOIN?