Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by googie
-
error with derived table query
Sorry...I should have mentioned the things that I have already tried. I did try using the keyword AS and have played with spacing (didn't think it would make a difference but worth a try) and neither has helped. I have renamed the table as well as played with the derived table name in the...- googie
- Post #3
- Forum: Microsoft SQL Server: Programming
-
error with derived table query
I am using ASP to build a query which includes derived tables. When I loaded the page I get the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ' '. In an attempt to troubleshoot I have simplified the query and table to it's simplies form and am...- googie
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
