query not working in Mysql

ravi.xolve · 03-14-2007, 02:09 PM

queries like:

(select customer_name from customer)
intersect
(select customer_name from depositor)

and similarily EXCEPT is not being recognised by mysql and documnetation make no mention as such.
pls help

acid_kewpie · 03-14-2007, 02:15 PM

mysql is not ansi sql92 compliant, there are some functions that it doesn't support, most notably complex selects... as you've found out.

gilead · 03-14-2007, 02:53 PM

Can you use something like this instead:

Code:

select CUSTOMER_NAME from CUSTOMER where CUSTOMER_NAME in (select CUSTOMER_NAME from DEPOSITOR)

That should return customers from the customer table that are also depositors.

acid_kewpie · 03-14-2007, 03:26 PM

mysql does sub queries now does it? didn't think it would do that either...

jlinkels · 03-14-2007, 07:01 PM

Subqueries are recognized in mysql > 4.21 (if I am not mistaken.) For sure not *every* version does it. Be careful and check the mysql docs.

I think this query should do what you need:

select customer.customer_name, depositor.customer_name from customer inner join depositor where customer.customer_name= depositor.customer_name

jlinkels