How do I write a select with multiple subqueries?

Hey there, I'm trying to figure out how to write this postgres query using Drizzle:

select query_a.*, query_b.* from (select * from gpus) as query_a, (select * from products) as query_b;

select query_a.*, query_b.* from (select * from gpus) as query_a, (select * from products) as query_b;

2 Replies

Aaroned•8mo ago

@Alan I believe you are trying to do a cross join see https://github.com/drizzle-team/drizzle-orm/issues/1414 workaround is to use fullJoin(column, sql``true``)

AlanOP•8mo ago

Thanks!