Hello,
Roger Baklund schrieb am Freitag, 17. Oktober 2003 um 23:40:
> ok, then something is obviously wrong. :)
> Try selecting some columns from each table, to see what is going on:
> SELECT a.ID,b.EAN,b.ISRC,c.StationID,d.status,c2.StationID,d2.status
> ...
I found the problem: Normally, the
* Andreas Ahlenstorf
> 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
> > L
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
>
* Andreas Ahlenstorf
> Roger Baklund schrieb am Freitag, 17. Oktober 2003 um 01:56:
>
> > I think you need the LEFT JOIN:
> > http://www.mysql.com/doc/en/JOIN.html >
>
> I thought about that before, but how to catch up the problem, that I
> have different tables where I have to get the ProdID and t
Hello,
Roger Baklund schrieb am Freitag, 17. Oktober 2003 um 01:56:
> I think you need the LEFT JOIN:
> http://www.mysql.com/doc/en/JOIN.html >
I thought about that before, but how to catch up the problem, that I
have different tables where I have to get the ProdID and the
StationID?
Andreas
--
Hello,
Peter Brawley schrieb am Freitag, 17. Oktober 2003 um 10:01:
> What you're looking for is a syntax like CASE WHEN ... JOIN I think
> that's not in SQL99 (just off the top of my head, such a syntax would seem
> likely to defeat any optimiser). You're going to have to (i) store the
Jep
rf
To: [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 5:49 PM
Subject: 'Selective' joins
Hello,
I'm having a tricky problem: I've got a database table (PicklistData
with three fields, which I have to use for a join to get the data,
which is associated with
* Andreas Ahlenstorf
> I'm having a tricky problem: I've got a database table (PicklistData
> with three fields, which I have to use for a join to get the data,
> which is associated with them. They are called EAN, ISRC and
> LabelProductCode. Until now, there's nothing difficult. But a thing,
> w
Hello,
I'm having a tricky problem: I've got a database table (PicklistData
with three fields, which I have to use for a join to get the data,
which is associated with them. They are called EAN, ISRC and
LabelProductCode. Until now, there's nothing difficult. But a thing,
which makes the problem i
