Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: How to replace dlookup in sql Server

    I am moving access qrys to sql server. Any recomendations on how i should handle the DLOOKUP function ?

    also this is in a select statemen like

    Select a, b, c, d, e,f, DLookUp('[Grouping Value]','tblRating','[Rating]='' & [Rating Group] & ''')
    FROM A inner join B
    ON blabla
    inner join c
    ON blabla
    inner join d
    ON blabla
    inner join e
    ON blabla
    inner join f
    ON blabla
    Last edited by mikezx10; 06-24-08 at 14:13.

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    DLOOKUPs must be turned into another JOIN | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts