[RESOLVED] Query problem.Plz help.

[ramu_rp2005]

I've a query in which i need a distinct field but even after giving distinct keyword it's not working.Plz help me to to get this distinct field. The distinct field is stream_name.

The query is

Select TTTT.* from 

(Select distinct stream_name,stream_id,stream_prgm_count,stream_location,stream_mux_bitrate,stream_size,stream_packet_size,stream_type,TTT.* from 

(Select TT.*,pcr_sid,pcr_prgm_num,pcr_pid from 

(Select *,case when audio_sid is NULL then video_sid ELSE audio_sid END as SID,case when audio_prgm_num is NULL then video_prgm_num ELSE audio_prgm_num END as PRNO from 

(Select audio_sid,audio_prgm_num,video_sid,video_prgm_num, audio_pid,audio_type,audio_sr,audio_mode,audio_bitrate,video_pid,video_type,video_userdata,video_resolution,video_chroma_format,video_aspect_ratio,video_frame_rate,video_bitrate from audio a left join video v on(audio_sid=video_sid and audio_prgm_num=video_prgm_num) 

union 

select audio_sid,audio_prgm_num,video_sid,video_prgm_num,audio_pid,audio_type,audio_sr,audio_mode,audio_bitrate,video_pid,video_type, video_userdata,video_resolution,video_chroma_format,video_aspect_ratio,video_frame_rate,video_bitrate from video vleft join audio a on (audio_sid=video_sid and audio_prgm_num=video_prgm_num))T)TT 

right join 

pcr_info p on (TT.SID=p.pcr_sid and TT.PRNO=p.pcr_prgm_num))TTT 

right join stream s on (s.stream_id=TTT.SID))TTTT 

where video_resolution like '%720x576i%' order by stream_name,video_pid,audio_pid;

[bradgrafelman]

Umm... gulp well that's definitely the longest query I've seen in a while.

Perhaps adding a 'GROUP BY stream_name' would return what you're looking for?

Now, I'm a bit lost in your query, so I can't really suggest where to put that.

[ramu_rp2005]

thank u very much.Problem is resolved.