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_membe r.is_active, nhb_group_membe r.group_id, nhb_group_membe r.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_nam e from (nhb_group_memb er, nhb_group A, nhb_group B) right join nhb_group on A.group_id = B.group_id where A.group_id = nhb_group_membe r.group_id and nhb_group_membe r.user_id = 'PER06262000.00 0000000002';
ERROR: syntax error at or near "," at character 267
select distinct 'default' as data_source, nhb_group_membe r.is_active, nhb_group_membe r.group_id, nhb_group_membe r.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_nam e from (nhb_group_memb er, nhb_group A, nhb_group B) right join nhb_group on A.group_id = B.group_id where A.group_id = nhb_group_membe r.group_id and nhb_group_membe r.user_id = 'PER06262000.00 0000000002';
ERROR: syntax error at or near "," at character 267