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
0 Replies