Post reply

Multy part identifyer Bite...table not found

  • April 25, 2009 at 12:57 am

    #203879

    DELETE DAO...fnb_debtor_branchmapping

    FROM fnb_debtor_branchmapping_sync AS a

    WHERE DAO...fnb_debtor_branchmapping.debtor_code=a.debtor_code

    AND DAO...fnb_debtor_branchmapping.branch_code=a.branch_code

    in this query i am getting an error

    The multi-part identifier "DAO...fnb_debtor_branchmapping.debtor_code" could not be bound.Is there any solution to overcome it.

    in this DAO is my linked server

  • April 25, 2009 at 3:42 am

    #983912

    Does this work?

    DELETE d

    FROM DAO...fnb_debtor_branchmapping d INNER JOIN fnb_debtor_branchmapping_sync AS a ON d.debtor_code=a.debtor_code

    AND d.branch_code=a.branch_code

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 30, 2009 at 4:08 am

    #986530

    DELETE DAO...fnb_debtor_branchmapping

    FROM fnb_debtor_branchmapping_sync AS a

    Inner Join DAO...fnb_debtor_branchmapping d on d.debtor_code=a.debtor_code

    d.branch_code=a.branch_code

    Even I get confuse in aliases when use FROM in DELETE and UPDATE.

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

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

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