By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,826 Members | 2,384 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,826 IT Pros & Developers. It's quick & easy.

Syntax error doesn't make sense...

P: 7
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
Sep 19 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.