How do I write a select where in subquery?

[evaogbe]

How would I write this in drizzle:

SELECT Id, FirstName, LastName, Country
  FROM Customer
 WHERE Country IN 
       (SELECT Country 
          FROM Supplier) 

I tried inArray but it gave me a TypeError

[evaogbe]

My problem was that I was ending the subquery with as.

// WRONG

await db
    .select()
    .from(table.customer)
    .where(
      inArray(
        table.customer.country,
        db.select({ country: table.supplier.country }).from(table.supplier).as("s")
      )
    )

// RIGHT

await db
    .select()
    .from(table.customer)
    .where(
      inArray(
        table.customer.country,
        db.select({ country: table.supplier.country }).from(table.supplier)
      )
    )