SQL Server Performance Forum – Threads Archive
select * from (select)
Is there a problem in the way I am calling this query: select * from (select * from authors) I am getting an error: Line 2: Incorrect syntax near ‘)’ Pl suggest. Thanx
May be you coult tell us what do you want to do, because that does not work. Somthing like: insert into A (select * from B) will work.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
You have to use alias name select * from (
select * from authors) T Madhivanan Failing to plan is Planning to fail
Why you are using same query.
simply use select * from authors.
generally use derived table method to get different set of resultset and combining all together.
Your sample doesn’t make too much sense. [<img src=’/community/emoticons/emotion-5.gif’ alt=’
![Wink ;) ;)](styles/default/xenforo/smilies/wink.png)
I think he wants to use derived table
Thats why he posted a question like this
Madhivanan Failing to plan is Planning to fail
Yes, I wanted to use a derived table and the table alias thing worked. Thanx Madhivanan.
]]>