Revision history [back]
 | 1 | initial version |
To extract information from a one-to-many relationship in Supabase, you can use a JOIN clause in a SQL query. For example, let's say you have two tables, "orders" and "order_items", where each order can have multiple items. To extract information from both tables, you can use the following query:
SELECT orders.*, order_items.*
FROM orders
JOIN order_items ON orders.id = order_items.order_id
WHERE orders.id = 123
This query will return all columns from both tables for the order with the ID of 123, and will join the tables based on the "orderid" column in the "orderitems" table and the "id" column in the "orders" table. You can customize the query to retrieve specific columns and filter the results as desired.