topic Re: Using DERIVED TABLES with SELECT in Operating System - HP-UX

Using DERIVED TABLES with SELECT

prandip — Thu, 15 May 2003 19:12:37 GMT

I am having problems retrieving information using SELECT from derived tables. Here's an example of the code:

SELECT . FROM (select FROM )

e.g.
1) SELECT DISTINCT n.pk_node, RTRIM(n.corp_name) + '/' + RTRIM(n.name) AS 'name'
FROM
(
SELECT s.pk_node
FROM service s
JOIN requestor_to_service rs ON s.dts_resp_id = rs.dts_resp_id
JOIN node n ON n.pk_node = rs.pk_node
AND n.ext_node_info LIKE @ext_node_info + '%'
) t
JOIN node n ON t.pk_node = n.pk_node

2) select t.num from (select num=1) t

I get the error: Incorrect syntax near the keyword SELECT

Kindly advice. I am converting from SQL Server to Sybase. This wasn't an issue in SQL Server.

Re: Using DERIVED TABLES with SELECT

Yogeeraj_1 — Thu, 15 May 2003 19:24:17 GMT

hi,

2.
"select num=1" does not seem to be correct hence the syntax error.

i guess it should be "select from "

what is the error for case 1?

revert

Yogeeraj

Re: Using DERIVED TABLES with SELECT

prandip — Thu, 15 May 2003 19:35:04 GMT

Hi Yogeeraj,
Thanks but you didn't get my problem properly. The second SQL was just a simplified form of the use of derived tables for my cause. That doesn't exist for me in the real sense.
Anyway, that query is fine as per SQL Server syntax. I am facing problems using derived tables instead of actual tables after the 'FROM' clause. SQL Server allows that. Sybase is giving me a no-no.
Kindly advice.

Revert.

Prandip