REPOST: Re: help needed with a SQL query

From: Keith Boulton <kboulton_at_ntlworld.com>
Date: Thu, 24 Jan 2002 21:13:05 -0000
Message-ID: <5$--$%%%_$_%%-%_%$@news.noc.cabal.int>

Your question implies a bad database design, but assuming each column value can be present only once you coud use

select title, min(video) video, min(dvd) dvd, min(vod) vod from <table> group by title

Sunil Pant <spant_at_eline.com> wrote in message news:vk_38.221$497.8376_at_sea-read.news.verio.net...
> Sorry for the mistake in earlier posting.
> I've a query that returns the following result set:
>
> title video dvd vod
> monster NULL 50493 NULL
> monster 48359 NULL NULL
>
> I want to display the above query as follows:
> title video dvd vod
> monster 48359 50493 NULL
>
> monster
>
> Any ideas would be appreciated.
> Thanks,
> SP
>
>
>

WAS CANCELLED BY =======: From: "Keith Boulton" <kboulton_at_ntlworld.com> Control: cancel <jJ_38.17858$Ph2.2915912_at_news2-win.server.ntlworld.com> Subject: cmsg cancel <jJ_38.17858$Ph2.2915912_at_news2-win.server.ntlworld.com> Date: Mon, 28 Jan 2002 00:57:17 GMT Message-ID: <cancel.jJ_38.17858$Ph2.2915912_at_news2-win.server.ntlworld.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!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.gamma.ru!Gamma.RU!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40726099

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 - 15:13:05 CST