INSERT SELECT

Hallo, I am trying to insert into a table HFacility a FacilityID, HotelID FROM Facility. Using Select.
Both HFacility and Facility have columns FacilityID, HotelID with same DataType.

Insert INTO HFacility
Select FacilityID, HotelID
FROM Facility

I am getting this error:
Server: Msg 213, Level 16, State 4, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

Thank you for your helpTry;

Insert INTO HFacility (FacilityID, HotelID)Select FacilityID, HotelIDFROM Facility

|||WORKS - Impressive Thank You Very MUCH

One more question:
What if I want to
Insert INTO HFacility (FacilityID)Select FacilityIDFROM Facility
But foreach inserted row insert a constant value for HotelID. (Depending on a situation)|||

rekoms:

WORKS - Impressive Thank You Very MUCH

One more question:
What if I want to
Insert INTO HFacility (FacilityID)Select FacilityIDFROM Facility
But foreach inserted row insert a constant value for HotelID. (Depending on a situation)

insert into HFacility (HotelID, FacilityID) select 1, FacilityID from Facility

The above will use 1 for each HotelID.

|||Lovely thank you