Hello,
Roger Baklund schrieb am Freitag, 17. Oktober 2003 um 14:24:
> SELECT IF(ISNULL(d.ProdID),d2.status, d.status) AS status
> FROM Picklists AS a
> LEFT JOIN PicklistData AS b ON
> a.ID = b.Picklist
> LEFT JOIN ProdID AS c ON
> b.EAN = c.EAN
> LEFT JOIN EncodingData AS d ON
> c.StationID = d.StationID AND
> c.ProdID = d.ProdID
> LEFT JOIN Trackdata AS c2 ON
> b.ISRC = c2.ISRC
> LEFT JOIN EncodingData AS d2 ON
> c2.StationID = d2.StationID AND
> c2.ProdID = d2.ProdID
> WHERE a.ID = '1'
Hum... The query takes something around 30 seconds and returns more or
less 3 mio rows with the same result. It should return only one
row. :(
- Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
