I still have a question about subqueries. I know there are two types of subqueries, the first is just like the following :
Select (Select count(*) from abteilung), pname from Perso
So, it has a simple "Select (select ...)...)" form.
But sometimes there comes the Error (sorry, don't know the errornumber) : "Subquery not allowed"
In this case I make a workaround :
Select first from table, (select column first FROM table) tab01
So, here I have to take an alias parameter for the subquery, which is explained in the FROM part.
But, I don't realised yet, whether there is a rule when to take the first or the second version.
Is there a page in the docu somehow ?
Here http://www.sapdb.org/7.4/htmhelp/60/515f3eca2a11d2a97100a0c9449261/content.htm I found nothing...
Best regards, Danny
-- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
