[cacouncill94]

I have a code in access that i am transfering into a TSQL database and there is a right join in the access portion, how does that translate into TSQL or does it not?

[r937]

it translates just fine

me, i never write right joins, so if i were converting this query, i'd change it into a left join, but that's a matter of personal taste only