The multi-part identifier could not be bound.

• cronicavenger

  Valued Member

  Points: 61

  More actions

  October 27, 2009 at 4:54 pm

  #156350

  Hey all,

  I'm trying to select into an existing table whilst matching customer IDs but its coming up with the error -->

  The multi-part identifier "dbo.tblCUSTOM281009.icustID" could not be bound.

  The code:

  SELECT iSalutation

  INTO dbo.tblCUSTOM281009

  FROM dbo.tblCustPerson

  WHERE dbo.tblCustPerson.iCustID = dbo.tblCUSTOM281009.icustID

  order by iSalutation

  The idea is to select the corresponding iSalutation(eg 1,2,3 etc) and then match it to the icustID (1, 2, 8000).

  Thank you for your help.

• huston.dunlap

  SSCommitted

  Points: 1551

  More actions

  October 27, 2009 at 5:18 pm

  #1071516

  The problem is your where clause. You are doing an equal statement on two different tables but haven't actually joined them together.

  I am guessing the "dbo.tblCUSTOM281009" in your where clause should be "dbo.tblCustPerson"

  cronicavenger (10/27/2009)

  ---

  Hey all,

  I'm trying to select into an existing table whilst matching customer IDs but its coming up with the error -->

  The multi-part identifier "dbo.tblCUSTOM281009.icustID" could not be bound.

  The code:

  SELECT iSalutation

  INTO dbo.tblCUSTOM281009

  FROM dbo.tblCustPerson

  WHERE dbo.tblCustPerson.iCustID = dbo.tblCUSTOM281009.icustID

  order by iSalutation

  The idea is to select the corresponding iSalutation(eg 1,2,3 etc) and then match it to the icustID (1, 2, 8000).

  Thank you for your help.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  October 27, 2009 at 11:29 pm

  #1071555

  Don't know if I understand what exactly you want.

  Insert InTo tblCUSTOM281009(iSalutation )

  SELECT iSalutation

  FROM dbo.tblCustPerson

  Inner Join dbo. tblCUSTOM281009 On dbo.tblCustPerson.iCustID = dbo.tblCUSTOM281009.icustID

  order by dbo.tblCustPerson.iSalutation