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! Quote 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. Quote 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 (?) Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.