Home » SQL & PL/SQL » SQL & PL/SQL » mixing rows
mixing rows [message #250382] Mon, 09 July 2007 19:59 Go to next message
vamsik
Messages: 15
Registered: February 2007
Junior Member
Hi all,
I have to write a query based n following requirement.please help me.
<pre>
RESULT
ItemCd ItemCdDesc GenericName ProductName NDCCd
15475 HIBTITER PRES Haemophilus HIBTITER 00005-0104-32
24595 HIBTITER PRES Haemophilus HIBTITER 00005-0104-32
15475 HIBTITER PRES Haemophilus HIBTITER 00005-0104-32
24595 HIBTITER PRES Haemophilus HIBTITER 00005-0104-32

JCode CurrentAWPPackagePrice
90645 141.91
90645 141.91
90648 141.91
90648 141.91

I need result like

ItemCd ItemCdDesc GenericName ProductName NDCCd
15475 HIBTITER PRES Haemophilus HIBTITER 00005-0104-32
24595 HIBTITER PRES Haemophilus HIBTITER 00005-0104-32

JCode CurrentAWPPackagePrice
90645, 90648 141.91
90645, 90648 141.91
</pre>

Thanks,
vamsi.
Re: mixing rows [message #250387 is a reply to message #250382] Mon, 09 July 2007 21:02 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SELECT DISTINCT ....
Re: mixing rows [message #250418 is a reply to message #250382] Tue, 10 July 2007 00:32 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow How to format your posts and use the "Preview Message" button to verify your post.

Regards
Michel
Previous Topic: Exception handler
Next Topic: Problem in Date - Group by
Goto Forum:
  


Current Time: Sat Dec 10 11:01:17 CST 2016

Total time taken to generate the page: 0.06662 seconds