Are you trying to do an inner join where you only pull back contacts who belong
to a company?
Jeremy Burns
Class Outfit
jeremybu...@classoutfit.com
http://www.classoutfit.com
On 15 Jun 2011, at 17:44, Zuha wrote:
Seems like this should be easy, and maybe I'm just missing how to do
it, but I
Close... select where we only pull back contacts where the company
belongsTo contact
On Jun 15, 3:00 pm, Jeremy Burns | Class Outfit
jeremybu...@classoutfit.com wrote:
Are you trying to do an inner join where you only pull back contacts who
belong to a company?
Jeremy Burns
Class Outfit
INNER was the word I needed to remember to get an alternative to
work.
For other people here's what the end query (which returns the same as
the above query) turned out to be.
SELECT `Contact`.`id`, `Contact`.`name` FROM `contacts` AS `Contact`
INNER JOIN contact_companies AS `ContactCompany`