5 replies

Left join with JSON

I'm using PlanetScale (MySQL) and have 2 tables: orders and products.
Every order contains basic info about the ordered products (see screenshot).

Is there a way to do this?:

import { orders, products } from '$lib/server/db/schemas/products';

db
    .select()
    .from(orders)
    .leftJoin(products, inArray(products.id, /*orders.products.map(({ id }) => id)*/)),

import { orders, products } from '$lib/server/db/schemas/products';

db
    .select()
    .from(orders)
    .leftJoin(products, inArray(products.id, /*orders.products.map(({ id }) => id)*/)),

I would like it take the ids from the

orders.products

orders.products

array and select those products.

Drizzle Team•3y ago•

5 replies

broly

Left join with JSON

I'm using PlanetScale (MySQL) and have 2 tables: orders and products.
Every order contains basic info about the ordered products (see screenshot).

Is there a way to do this?:

import { orders, products } from '$lib/server/db/schemas/products';

db
    .select()
    .from(orders)
    .leftJoin(products, inArray(products.id, /*orders.products.map(({ id }) => id)*/)),

import { orders, products } from '$lib/server/db/schemas/products';

db
    .select()
    .from(orders)
    .leftJoin(products, inArray(products.id, /*orders.products.map(({ id }) => id)*/)),

I would like it take the ids from the

orders.products

orders.products

array and select those products.

Left join with JSON

Similar Threads

Left join with JSON

Similar Threads

Similar Threads

Similar Threads