5 replies

Select All from Sub-query

Hi,

I'm trying to figure out if it's possible for me to select all the columns from a sub-query.

I imagine if it were possible it'd be something like this:

const subQuery = db().select({ ... }).from(...).as("subquery");

const query = db()
    .select({ ...subQuery })
    .from(subQuery);

const subQuery = db().select({ ... }).from(...).as("subquery");

const query = db()
    .select({ ...subQuery })
    .from(subQuery);

Do I have to name all the columns?

Select All from Sub-query

Similar Threads

Select All from Sub-query

Similar Threads

Similar Threads

Similar Threads