Post reply

MULTI PART IDENTIFIER -----error

  • April 17, 2010 at 5:13 am

    #223530

    INSERT INTO Tradetable (Journal_No) SELECT [FINAL_DATA_ENTRY].[DBO].[Journal].JournalNo FROM [FINAL_DATA_ENTRY].[DBO].Journal where [FINAL_DATA_ENTRY].[DBO].[TRADETABLE].TradeNo=[FINAL_DATA_ENTRY].[DBO].[Journal].TradeNo

    This is the query i used but it throws " the multi part identifier" tradtable.tradeno not bound

    please help me...

    Thanks in Advance

  • April 17, 2010 at 5:19 am

    #1153306

    You only have [FINAL_DATA_ENTRY].[DBO].Journal in your FROM clause. You need to join it to [FINAL_DATA_ENTRY].[DBO].[TRADETABLE].

    I don't know the join type but something like

    INSERT INTO Tradetable (Journal_No)

    SELECT Journal.JournalNo

    FROM [FINAL_DATA_ENTRY].[DBO].Journal Journal

    INNER JOIN [FINAL_DATA_ENTRY].[DBO].[TRADETABLE] Tradetable

    ON Tradetable.TradeNo= Journal.TradeNo


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply