Quering client by phone number

[itazev]

Hey everybody!

 

I'm trying to build up a query to find a client by its telephone number.

In this case I use tel LIKE '%55%' to find phone number containing '55' on it.

The problem is that it results clients that even have a phone number registered.

Probably it is due to some JOIN instruction missing. I don't know exactly.

 

clients and contacts are referenced by primary/foreign key in InnoDB

 

SELECT clients.id, clients.name, contacts.tel, contacts.tel2
FROM clients, contacts WHERE tel LIKE '%55%' GROUP BY name;

 

Thank you for helping!

[fenway]

How are clients and contacts related? If they aren't, you need a UNION, not a JOIN.

[bubblegum.anarchy]

itazev: There still needs to be an explicit join in the query statement (?)