Please help if you can...

Hi everybody, I'm new to MySQL and have got the following code that works with Oracle SQL... After looking at the documentation I realised that DECODE seems to be reserved for encryption... any idea of how this would work with MySQL? Here is the code: The tables are as follows table

Fw: DECODE

Hi everybody, I'm new to MySQL and have got the following code that works with Oracle SQL... After looking at the documentation I realised that DECODE seems to be reserved for encryption... any idea of how this would work with MySQL? Here is the code: The tables are as follows __