Syntax error doesn't make sense...

Can anybody tell me what I'm doing wrong with my syntax with the following statement? Immediately following is the error. The bugger of this is that this statement works on MySQL, MS SQL, ORACLE, DB2, H2, and even hsqldb. Any suggestions would be appreciated....

select distinct 'default' as data_source, nhb_group_member.is_active, nhb_group_member.group_id, nhb_group_member.has_mojo, A.group_owner, A.group_name, A.description, A.active_date, A.expire_date, A.is_public, B.group_name as group_owner_name from (nhb_group_member, nhb_group A, nhb_group B) right join nhb_group on A.group_id = B.group_id where A.group_id = nhb_group_member.group_id and nhb_group_member.user_id = 'PER06262000.000000000002';

ERROR: syntax error at or near "," at character 267