TanStackT
TanStack5mo ago
18 replies
sophisticated-purple

subquery doesn't work in join

// not work
const { data: a } = useLiveQuery((q) =>
  q.from({ product: productsCollection })
    .leftJoin({ tried: createTriedByUserId(user?.id, true) }, ({ tried, product }) => eq(tried.productId, product.id))
)

// work
const { data: a } = useLiveQuery((q) =>
  q.from({ tried: createTriedByUserId(user?.id, true) })
    .leftJoin({ product: productsCollection }, ({ tried, product }) => eq(tried.productId, product.id))
)
Was this page helpful?