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, that's what I tried the last days, but I wasn't able to find a solution without syntax errors. The problem are the two different tables where I have to get the StationID and ProdID from. Without the two different tables, I could use JOIN ON CASE... that should work, I saw such a solution in a usenet posting. > results of an initial query in a temp table and work from there, or (ii) use > a scripting language. If the system is going to be running for a while, > choosing (ii) now might save you a little time later when MySQL implements > stored procs (since it will be easier to port a script to a SP). Hum... I'll ask my people, if it's possible to have one table where I can find the EAN, ISRC and LabelProductCode. I won't have temporary tables because they don't solve our problem with a lot of chaos and mess in our tables. But if that is not possible, I'll try that with the temporary table. Andreas -- Eine Ferengi-Erwerbsregel besagt: Pass auf, was du verkaufst; es könnte genau das tun, was der Kunde erwartet. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
