Expert !
I have a table
NAMETAB
FIRST_NAME CHAR(20)
MID_NAME CHAR (20)
LAST_NAME CHAR(20)
....
...
I rows like
FIRST_NAME MID_NAME LAST_NAME
ANDY x COLLINS
ANDY y COLLINS
ROCHELLE a ROB
ROCHELLE a ROB
MIKE s TYSON
GEORGE D CLOONEY
GEORGE D CLOONEY
ROBERT H HILLEN
ROBERT J HILLEN
....
....
I want to list rows with same FIRST_NAME and LAST_NAME but different MID_NAME
eg:
ANDY x COLLINS
ANDY y COLLINS
ROBERT H HILLEN
ROBERT J HILLEN
can anybody please provide me with the SQL to get this result set.
Thanks in advance..
- WAS CANCELLED BY =======:
From: wonderinguy_at_hotmail.com (Wonderinguy)
Control: cancel <6950e82.0201241150.65aa2b00_at_posting.google.com>
Subject: cmsg cancel <6950e82.0201241150.65aa2b00_at_posting.google.com>
Date: Mon, 28 Jan 2002 01:18:04 GMT
Message-ID: <cancel.6950e82.0201241150.65aa2b00_at_posting.google.com>
X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1
Path: news.uni-stuttgart.de!cert.uni-stuttgart.de!news.belwue.de!news.uni-ulm.de!rz.uni-karlsruhe.de!blackbush.xlink.net!blackbush.de.kpnqwest.net!fu-berlin.de!news.maxwell.syr.edu!xmission!news.svpal.org!nntp.cifnet.net!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40725850
This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.
Received on Thu Jan 24 2002 - 13:50:15 CST