I am running into some hiccups trying to sort a list of products by price, I took a look at the documentation, but I am a bit confused about the

foreignTable

property. I tried to pass the name of the table and the name column that makes the foreign-key relation, but none of those seem to work. Any advice will be appreciated

const products = await supabase
    .from("products_tagged")
    .select("id, productID(*)")
    .eq("tagID", 7)
    .order("price", { foreignTable: "productID" });

> but none of those seem to work What result are you getting? Maybe try with

products

instead of

productID

js
 await supabase
    .from("products_tagged")
    .select("id, products(*)")
    .eq("tagID", 7)
    .order("price", { foreignTable: "products" });