insert a column into a table from another table with different names

INSERT INTO isvgroups (ISVApp)
SELECT isvapplication  FROM SLXActApplications
WHERE SLXActApplications.ISVApplication<>isvgroups.ISVApp

this comes back and fails

Msg 4104, Level 16, State 1, Line 3
The multi-part identifier "isvgroups.ISVApp" could not be bound.
Chris MichalczukConsultantAsked:
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
you want to do this:

INSERT INTO isvgroups (ISVApp)
SELECT isvapplication  FROM SLXActApplications
WHERE NOT EXISTS( SELECT null FROM isvgroups WHERE SLXActApplications.ISVApplication = isvgroups.ISVApp )

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.