Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013
    Posts
    1

    Unanswered: SQL Query to MS Access SQL Query

    Hi all,

    I have below a SQL Query.
    How will this look like in a MS Access SQL Query?

    Code:
    UPDATE TB_EP_RIJSWIJK
    SET TB_EP_RIJSWIJK.TITLE = Stardump.TI,
    TB_EP_RIJSWIJK.VOLUME = Stardump.VOLS,
    TB_EP_RIJSWIJK.REPORT_YEAR = Stardump.YEAR
    FROM TB_EP_RIJSWIJK, Stardump
    WHERE TB_EP_RIJSWIJK.SHELL_REFERENCE = Stardump.Call
    Little explaining:

    We have a linked table source called Stardump
    with 4 relevant Columns: CALL, TI, VOLS, YEAR

    The Table TB_EP_RIJSWIJK
    has 4 relevant columns: SHELL_REFERENCE, TITLE, VOLUME, REPORT_YEAR

    Stardump.CALL is same as TB_EP_RIJSWIJK.SHELL_REFERENCE
    Stardump.TI is same as TB_EP_RIJSWIJK.TITLE
    Stardump.VOLS is same as TB_EP_RIJSWIJK.VOLUME
    Stardump.YEAR is same as TB_EP_RIJSWIJK.REPORT_YEAR

    What it should do:

    If Stardump.CALL match with TB_EP_RIJSWIJK.SHELL_REFERENCE
    then Fill the match on TB_EP_RIJSWIJK.SHELL_REFERENCE to column:
    TB_EP_RIJSWIJk.TITLE, TB_EP_RIJSWIJK.VOLUME, TB_EP_RIJSWIJk.REPORT_YEAR
    From Stardump.CALL Stardump.TI Stardump.VOLS, Stardump.REPORT_YEAR

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    cant see anything that isn't compliant with with ANSI SQL, so it should work fien with Access/JET

    Access does converge on things like joins where it loves brackets and uses a slightly different syntax.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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