Tsql Help | The Select List For The Insert Statement Contains Fewer Items Than The Insert List

Please see my query below, I have counted the columns a number of times and also I have checked the commas, they seem to be fine but I keep on getting the error The select list fo

Solution 1:

Your list of fields in the SELECT portion and INSERT (..column list..) is out by 1 because of a missing comma here:

PhysicianPhone
PhysicianZip,

In the SELECT. It is aliasing Phone as Zip, and everything else falls out of step.