How to create/write a SQL query to find the salesperson and customer who belongs to same city. Return salesman, cust_name&city

Question

I try to code it but it didn't show the output. Always in error.
I have trouble in making the query
https://www.sololearn.com/discuss/2993558/?ref=app
https://www.sololearn.com/discuss/2993558/?ref=app

Answer 1

SELECT salesman.name AS "Salesman",
customer.cust_name, customer.city
FROM salesman,customer
WHERE salesman.city=customer.city;

Hope it will help you ✌️🤠✌️