rewrite a RIGHT JOIN
Date: 11 Oct 2002 01:35:02 -0700
Here is my problem: I have an SQL query that works fine on DB2, but I need a query that produces the same results to work on MySql also. My DB2 query uses a RIGHT JOIN that is unsupported by MySql.
How should I rewrite my query ? Thank you in advance !
Here is the DB2 query:
SELECT PM.Id, PM.Name, PT_M.PrmTheme_Id FROM PromoTheme PT JOIN PrmTheme_Mecanism PT_M ONReceived on Fri Oct 11 2002 - 10:35:02 CEST
(PT_M.PrmTheme_Id=PT.Id) AND (PT.Id= ?)
RIGHT JOIN PromoMecanism PM ON
WHERE PM.Sty_Id= ?