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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

selecting from a sub-select statement

Status
Not open for further replies.
kelly27

kelly27

Technical User
May 10, 2003
2
US
I had a question similar to wcj's question. However I get a syntax error everytime I try and do another select statement after the from.
thanks
 
Sort by date Sort by votes
It would be easier, if you included the exact error message and your RDBMS.
Maybe your RDBMS doesn't support Derived Tables or you forgot the table alias:
select ..
from (select ...) tablealias

Dieter
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
SELECT COUNT distinct
Replies
5
Views
211
sal21
sal21
BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
207
carp
carp
BobThornton
  • Locked
  • Question
Count records until a record value changes
Replies
2
Views
346
carp
carp
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
197
mmiah1982
mmiah1982
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once
Replies
0
Views
146
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top