RE: [sap-basis] Open SQL Subquery
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Dave Thornburgh on Apr 15 at 1:36 AM |  Mark as helpful |
Christof -
It's all well and good that you really need it, but it's still a development
question rather than a Basis question. Most good basis folks know some SQL,
but not at the level you need.
Dave
From: Christof S via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: Wednesday, April 14, 2010 2:02 AM
To: Dave Thornburgh
Subject: RE:[sap-basis] Open SQL Subquery
Posted by christofs (Business
Analyst)
on Apr 14 at 5:06 AM
<http://it.toolbox.com/api/ContentVote/3437922/1/1/> Mark this reply as
helpfulMark as helpful
The error I get with a more complicated version is "SELECT is not defined in
the abap dictionary as a table, projection view or database view."
I need such a subquerry because the query to be used is more complicated, I
just want to get rid of this error with the subselect.
Thx!
---------------Original Message---------------
From: christofs
Sent: Wednesday, April 14, 2010 4:58 AM
Subject: Open SQL Subquery
> Hey there!
> I have to transfer a MS SQL query to Open SQL. Is there a possibility to
do a subselect? Like
> SELECT ID from ( SELECT ID sum from table as t where t~sum > 100).
>
> Help is appreciated! :-)
>
> Kind regards,
>
> Christof!
__.____._ It's all well and good that you really need it, but it's still a development
question rather than a Basis question. Most good basis folks know some SQL,
but not at the level you need.
Dave
From: Christof S via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: Wednesday, April 14, 2010 2:02 AM
To: Dave Thornburgh
Subject: RE:[sap-basis] Open SQL Subquery
Posted by christofs (Business
Analyst)
on Apr 14 at 5:06 AM
<http://it.toolbox.com/api/ContentVote/3437922/1/1/> Mark this reply as
helpfulMark as helpful
The error I get with a more complicated version is "SELECT is not defined in
the abap dictionary as a table, projection view or database view."
I need such a subquerry because the query to be used is more complicated, I
just want to get rid of this error with the subselect.
Thx!
---------------Original Message---------------
From: christofs
Sent: Wednesday, April 14, 2010 4:58 AM
Subject: Open SQL Subquery
> Hey there!
> I have to transfer a MS SQL query to Open SQL. Is there a possibility to
do a subselect? Like
> SELECT ID from ( SELECT ID sum from table as t where t~sum > 100).
>
> Help is appreciated! :-)
>
> Kind regards,
>
> Christof!
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Dave ThornburghSAP Basis Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
