rewrite a RIGHT JOIN

        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 !

Best regards,

        Dan

Here is the DB2 query:

	SELECT 
	   PM.Id, PM.Name, PT_M.PrmTheme_Id 
	FROM 
	 PromoTheme PT 
	JOIN PrmTheme_Mecanism PT_M ON 


	   (PT_M.PrmTheme_Id=PT.Id) AND (PT.Id= ?) 


	RIGHT JOIN PromoMecanism PM ON 


	   (PM.Id=PT_M.PrmMecanism_Id) 


	WHERE 
	   PM.Sty_Id= ?