Can I do a database search?

Question

SQL

I have a database with 3 tables.
Orders:

Companies

Customers


Using JOIN I connect them

SELECT * FROM `orders` LEFT JOIN companies ON orders.company_id=companies.id LEFT JOIN clients on orders.client_id=clients.id WHERE companies.id=clients.company_id

The output is:


This will be displayed on my site and I was wondering if I could implement a search by customer number in a table that is spliced ​​via JOIN?

Thanks in advance for your replies!

Answer 1

SELECT * 
FROM `orders` 
LEFT JOIN `companies` ON `orders`.`company_id` = `companies`.`id` 
LEFT JOIN `clients` ON `orders`.`client_id` = `clients`.`id` 
WHERE `companies`.`id` = `clients`.`company_id`
AND `clients`.`phone` = '1234567890'