heya,
To what i have read so far, we can't assign an SQl query statement to a variable that can be used afterwards, i.e.
A=select ...from... where...
then,
select...from A where...

thus we end up using nesting queries which i found so cumbersome

is there any reason behind this implementation decision which i can't see especially when the nesting queries are not dependent

thanks

Your "variables" are standard SQL features called views.

-PatP

If you are using Oracle, then the variable would be a reference cursor:

Code:

var rc refcursor;
...etc...
begin
  open :rc for 'select * from MyTable';
...etc...

Most of the different SQL and SQL-like dialects have a way of doing this. I just presented the view because it is pure SQL-89 (and earlier) standard. A view ought to work on any product that claims to be compatible with the SQL standard.

-PatP

True, best solution is views; maybe I should have said: 'the variable could also be a reference cursor'. Cheers.