Rows

[donlste]

Hi there,

Here is my problem,

I have a query, where I am trying to get one row for each record. However, as one of the Columns have two different entries, it's duplicating the record, with the change.

What I would like to do, is to get the column that's causing the duplicate, to appear next to it.

Instead of:-

526525 ORANGE round
526525 APPLE round

I would like

526525 ORANGE APPLE round

Does anyone know of a way I can do this via SQL.

Any help would be appreciated.

 

[mwolf00]

Does this get you what yo want?

SELECT
t1.myID,
t1.myFruit,
t2.myFruit,
t1.myShape
FROM
myTable t1,
myTable t2
WHERE t1.myID *= t2.myID
AND t1.myFruit <> t2.myFruit -- Just trying to help... LOL