OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
From: Csaba Szelenyi (szeloMINDMAKER.HU)
Date: Tue Jun 04 2002 - 08:12:31 CDT

  • Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

    Hi Paul,

    Probably your solution is INNER JOIN. But I cannot tell it wthout your DB
    structure and the exact query.

    Csaba

     | SELECT DISTINCT pm.PanelID, pm.ProbePanelID, pm.LogDate, sq.source FROM
     | Probe_MarkerPanel_Link pm, ProbePanel_Platform_Link pp, SNP_Platform
     | sp..............
     |
     | In the output there are chances that there will be
     | repeatition of record
     | with same PanelID with different LogDate or Source. I do not want this. I
     | need only one record for each PanelID. How to do it
     |

    ----------------------------------------------------------------
    Users Guide http://discuss.microsoft.com/archives/mailfaq.asp
    contains important info. Save time, search the archives at
    http://discuss.microsoft.com/archives/index.html .
    To unsubscribe, mailto:DCOM-signoff-requestDISCUSS.MICROSOFT.COM