That's the question i need to do :
For each row retrieved, show which employees or customers are from London and Winnipeg by embedding London and Winnipeg in the SELECT statement.
Thats what i a putted but the output is not what i want :
SELECT First_Name, Last_Name, (SELECT City FROM employees WHERE City = 'London' OR 'Winnipeg'), Customers_Name, Customers_LastName, (SELECT Customers_City FROM customers WHERE Customers_City = 'London' OR 'Winnipeg') FROM employees, customers WHERE City = 'London' OR 'Winnipeg' and Customers_City = 'London' OR 'Winnipeg'
Answer by Jon Crawford ·
that seems unnecessarily complicated, rather than just returning the city/customers_city for the items in your WHERE condition. Try using a CASE Statement, CASE WHEN city = 'London' THEN 'London ELSE 'Winnipeg' END, something like that.
Seems pointless though.