How can we help you today? How can we help you today?

Subquery placement

Not to be overly picky, but on the Subquery placement option you have the following code:
SELECT    *
FROM      ( SELECT    staffId
            FROM      personnel )
        CROSS JOIN ( SELECT a FROM b )

Neither of these is actually a subquery. They are both derived tables. It would actually be nice if this distinction was made and the two were treated differently.[/code]

While I might want (select a from b) in a subquery as in:
select *
from   table
where  a in (select a from b)

I may not want it in
select *
from   table
             join (select a
                    from   b) as aOnly

At the very minimum it might be nice to change the heading to derived tables/subqueries.
drsql
0

Comments

1 comment

Sort by
  • Andras B
    drsql wrote:
    ...

    At the very minimum it might be nice to change the heading to derived tables/subqueries.

    I absolutely agree with you, however the suggested heading is a bit long, especially if it i translated to other languages :).

    Andras
    Andras B
    0

Add comment

Please sign in to leave a comment.