Usage of subqueries

[erebus]

select E.some column names,F.some column names
from (select D.some column names,C.column names
from <table name> as C, (select A.some column names,B.some column names )as D)as E, <table name> as F.


Is the above query correct ?

[cburnett]

More or less - just add from A.B:

select E.some column names,F.some column names
from (select D.some column names,C.column names
from <table name> as C, (select A.some column names,B.some column names from A,B )as D)as E, <table name> as F.