INSERT INTO

[Fab]

why will this not work?

INSERT INTO #TEMP
SELECT *
FROM a
WHERE b IS NOT NULL

 

[RobFMS]

Are you writing a query for a SQL Server db or for an Access db?

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-