Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  problems with an insert query

Author  Topic  BOLNet Starting Member 5 Posts Posted - 2001-09-26 : 05:13:57 Hello, I have a problem with this query. The subquery works fine but when I do the INSERT it fails. Could anyone help me, please? INSERT INTO correspHotel (idLocal, idHotel) VALUES (SELECT idlocal FROM Continguts.dbo.local cl INNER JOIN localAnt ml ON ml.idLocalA = cl.idLocalAntic WHERE ml.idTipusLocal = 4, idHotel) Million thanks.