ajdorro Pirate
ajdorro Pirate
PostsComments
DTDrizzle Team
Created by ajdorro Pirate on 5/14/2024 in #help
Subquery in Delete
what is the correct way to write a delete statement with a subquery? example not working: 
      const department = db
        .select()
        .from(baseDepartment)
        .where(eq(baseDepartment.id, 21))
        .as("sq");

      const a = await db
        .with(department)
        .delete(baseDepartment)
        .where(eq(baseDepartment.id, department.id));
      const department = db
        .select()
        .from(baseDepartment)
        .where(eq(baseDepartment.id, 21))
        .as("sq");

      const a = await db
        .with(department)
        .delete(baseDepartment)
        .where(eq(baseDepartment.id, department.id));
error I am getting is: Missing from cause value for "sq"
1 replies