Mysql join predicate not working

arunpers · #1 (**permalink**) 12-11-03, 17:44

Hi all,
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:
SELECT *
FROM
requirement r,
ref_source s
WHERE
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?

r937 · #2 (**permalink**) 12-11-03, 18:00

mysql does not support the oracle proprietary "plus sign" syntax for outer joins

instead, just use the standard join syntax

Code:

select *
  from requirement r
left outer
  join ref_source s
    on r.source_code = s.source_code 
 where r.project_id = 0

rudy
http://r937.com/

arunpers · #3 (**permalink**) 12-11-03, 21:52

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??

r937 · #4 (**permalink**) 12-12-03, 04:24

because it's a separate product

Quote:

"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."
-- http://www.mysql.com/press/release_2003_35.html

rudy

Internet Services

Web Development

Digital Marketing

Consumer Tech