[plum] SQL question

[Tim Blankenship]

I know this is not a PLUM question per say but it is needed to make my PLUM app to work.

Alrighty I am using DTS on MS SQL to grab some data so I can put it in my Oracle db.
Problem is when I get the output I am returning duplicate results even though I used DISTINCT.
So not sure where I messed up but I figured there has to be atleast a couple of SQL geeks on the list.
I want it to display a single SN.

SELECT     DISTINCT { fn UCASE(LTRIM(RTRIM(R_Inventory.SerialNumber)))    } AS SN,
    { fn UCASE(LTRIM(RTRIM(R_Inventory.ProductName)))    } AS MODEL,
    { fn UCASE(LTRIM(RTRIM(R_CPU.CPUType)))    } AS PROCESSOR,
    { fn UCASE(LTRIM(RTRIM(R_CPU.CPUSpeed)))    } AS PROCESSOR_SPD,
    { fn UCASE(LTRIM(RTRIM(R_DIMMSlots.MemorySize)))    } / 1024 AS MEMORY

FROM    R_Inventory INNER JOIN R_CPU
     ON R_Inventory.DeviceName = R_CPU.DeviceName
    INNER JOIN R_DIMMSlots
      ON (R_Inventory.DeviceName = R_DIMMSlots.DeviceName)
WHERE     (R_Inventory.SerialNumber <> '')

--
Tim Blankenship
[EMAIL PROTECTED]
www.vespri.com