var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Mysql join predicate not working
I am trying to migrate an application from oracle to mysql and have trouble getting the join predicates work. I am using MySql 4.1 alpha version.
This is the query i want to use:
r.project_id = 0 AND
r.source_code = s.source_code (+);
I see examples of such queries on the MySql site but cannot seem to make it work. The datatype of the source_code columns in both the tables are the same char(2).
Any suggestions on what i am missing?
mysql does not support the oracle proprietary "plus sign" syntax for outer joins
instead, just use the standard join syntax
from requirement r
join ref_source s
on r.source_code = s.source_code
where r.project_id = 0
Thanks rudy. I realized now that I have searched the MaxDb manuals and found the syntax using oracle style (+)... By the way, why is maxDB seperate from MySql??
because it's a separate product
"MaxDB complements MySQL AB’s flagship MySQL® database... MaxDB by MySQL is a re-branded and enhanced version of SAP DB, SAP AG’s (NYSE: SAP) open source database.... MaxDB joins MySQL AB’s flagship product, the MySQL database server, in the MySQL AB database product line-up."