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. 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; 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. 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) Link to comment https://forums.phpfreaks.com/topic/51058-complex-or-simple-sql/#findComment-251275 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.