i need ur help

[Shishir]

Hi List ! I have one problem SELECT DISTINCT L.LINE_ID, L.DSCR , L.DSCR_LONG , QL.QUOTE_LINE_ID FROM LINE L,MKT_LINE ML,QUOTE_LINE QL WHERE ML.LINE_ID=L.LINE_ID AND QL.MKT_LINE_ID=ML.MKT_LINE_ID AND QL.INV_ID =10134 it result is     LINE_ID    DSCR DSCR_LONG    QUOTE_LINE_ID  10002 25     Commercial Property       10528  10002 25    Commercial Property        10529  10009 52    Workers Comp                 10530 i want to get those line where line id is unique but i can not ditch the Quote_line_id colum . Diffrent  quote_line id can  refer to same line . So i want to ask is there any way to row wise comparison in SQL itself. in above example i want to ditjch second record as it has same LINE_ID  as first one.   Plz help me..   thanx in advance.. Shishir Kumar Mishra Agni Software (P) Ltd., Bangalore-560055, India www.agnisoft.com