select results from customers where customer id is present in the orders table

[grumpyoldtechs]

SELECT orders.*, customers.* FROM orders LEFT JOIN customers ON orders.customer_id = customers.customer_id WHERE customers.$field LIKE '%$search%' ORDER BY $field ASC LIMIT $offset, $max_rows

sorry if my SQL is a mess SQL isn't my strong point. i need to select all the customers which are valid for the search in which the customer_id is present as a foreign key in the orders table.

basically only show customers which have placed orders.

[grumpyoldtechs]

solved im using an inner join

[scottrickman]

You can add a HAVING clause you your statement