Jaden
Jaden
PostsComments
DTDrizzle Team
Created by Jaden on 9/13/2024 in #help
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?
6 replies