Pardon, I misread. Select * from stock where code in (select code from stock group by code having count(*) >1)
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of free...@sohocare Sent: Friday, September 11, 2009 4:21 AM To: [email protected] Subject: Need help on "Select" command dear all GURU, Can anyone help me on how to use "SELECT * from stock .." command to get the following result? STOCK.DBF code description 100 book 100 +book 101 paper 102 pen 102 +pen 103 stamp 104 brush RESULT: (List of duplicate code) code description 100 book 100 +book 102 pen 102 +pen TIA --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001f01ca33ae$6960fb50$3c22f1...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
