Dr Use
Explore posts from serversDTDrizzle Team
•Created by Dr Use on 4/3/2025 in #help
Complex filter on query.
Hello everyone, here's the query :
I get the error : missing FROM-clause entry for table "productsordertable"
I can't find a way to filter the orders according to the user or the products.
For exemple I want the orders where the user name is "john".
Or I want the orders where some of the products name contains "foo".
PS : productsOrderTable has a column order_id as a foreign key
I can only filter according to the ordersTable direct columns
1 replies
DTDrizzle Team
•Created by Dr Use on 1/10/2025 in #help
define where query outside
I dont understand why this code works :
But not this one :
2 replies