rupeshp_shah
asked on
Subquery
Can we use subquery in the from clause in sybase .
We can do the same in oracle using inline views.
Is there any way to get the same in sybase
We can do the same in oracle using inline views.
Is there any way to get the same in sybase
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use subquery in from (like oracle). You can create real view for this.
But you can use subquery in select columns list (oracle can't ).
For example :
select a, (select b from tableB where ...) b from tableA ...
Creating temporary table is another option. Note that not like in oracle temporary tables are local for your session.
You need to create them in every session (while in oracle you create it only once and only data is local for session).
But you can use subquery in select columns list (oracle can't ).
For example :
select a, (select b from tableB where ...) b from tableA ...
Creating temporary table is another option. Note that not like in oracle temporary tables are local for your session.
You need to create them in every session (while in oracle you create it only once and only data is local for session).
In-line views (also known as "derived tables") are being added to ASE as a new feature in the
12.5.1 release, which should be available around late September.
12.5.1 release, which should be available around late September.
which version are you using?