Could not find a relationship between 'products' and 'prices'
I have two tables products and prices.
Prices has a foreign key relation to products with
When I try this query it says
I am doing this join correctly?
Prices has a foreign key relation to products with
product_id text references productsWhen I try this query it says
Could not find a relationship between 'products' and 'prices' in the schema cacheI am doing this join correctly?