#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Posts
    4
    Rep Power
    0

    Translating Access Right Join to TSQL


    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?
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,118
    Rep Power
    4274
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo