itazev Posted May 9, 2007 Share Posted May 9, 2007 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! Link to comment https://forums.phpfreaks.com/topic/50658-quering-client-by-phone-number/ Share on other sites More sharing options...
fenway Posted May 9, 2007 Share Posted May 9, 2007 How are clients and contacts related? If they aren't, you need a UNION, not a JOIN. Link to comment https://forums.phpfreaks.com/topic/50658-quering-client-by-phone-number/#findComment-249117 Share on other sites More sharing options...
bubblegum.anarchy Posted May 10, 2007 Share Posted May 10, 2007 itazev: There still needs to be an explicit join in the query statement (?) Link to comment https://forums.phpfreaks.com/topic/50658-quering-client-by-phone-number/#findComment-249449 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.