3 ms·
No. Think of it as "for order 1 list all clients", so it would be: SELECT * FROM clients WHERE client_id IN (SELECT client_id FROM orders WHERE order_id =
by mattmanser 12y ago
No. Think of it as "for order 1 list all clients", so it would be:
SELECT * FROM clients WHERE client_id IN (SELECT client_id FROM orders WHERE order_id = @order_id)
The GET /clients/1/orders is what would result in your query (for client 1 list all orders).