upgraded 3.23 to 5.0.16 and inner join query gives an error????

[Kendrick]

hello there,
I upgraded from mySQL 3.23 to mySQL 5.0.16 and an inner join query, now gets an error, and plz advice what I need to change about it? It also works on 4.0.22 mySQL for the same database.

Here's the query: select distinct ud.* from user_data ud, einsof_object eo inner join einsof_attribute ea1 on ( ud.user_data_id = ea1.for_einsof_object_id and ( ea1.attribute_name like '%LEC:Countries%' and ea1.attribute_value_string = 'UNITED STATES' )) where ud.user_data_id = eo.id and ud.approval_ind = 'Y' and ud.active_ind ='Y' and ud.red_flag_ind = 'N' and ud.user_form_id = 40712 order by eo.create_date desc

the error is in the "on clause" for the inner join: 1054: Unknown column 'ud.user_data_id' in "on clause"....

Any suggestions would be greatly appreciated!
Thanks, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --