otuatail Posted May 12, 2007 Share Posted May 12, 2007 You guys may think this is simple. I only want to show single records in a table E.G if this was Ebay I want to show all the fields in the transaction table where a customer transaction only appeared once. All the single transactions only. Is this easy to do? Desmond. Quote Link to comment https://forums.phpfreaks.com/topic/51058-complex-or-simple-sql/ Share on other sites More sharing options...
esukf Posted May 12, 2007 Share Posted May 12, 2007 Try something like SELECT * FROM table GROUP BY customer HAVING COUNT(customer) = 1; Quote Link to comment https://forums.phpfreaks.com/topic/51058-complex-or-simple-sql/#findComment-251267 Share on other sites More sharing options...
otuatail Posted May 12, 2007 Author Share Posted May 12, 2007 Super cool thanks. I can make it = 2 (although it does not show both) it does work Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/51058-complex-or-simple-sql/#findComment-251273 Share on other sites More sharing options...
MadTechie Posted May 12, 2007 Share Posted May 12, 2007 please click solved (bottom left) Quote Link to comment https://forums.phpfreaks.com/topic/51058-complex-or-simple-sql/#findComment-251275 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.