How do I write this sub query in MySQL???

[danielrc15]

HI,

I have this subquery written in Oracle SQL, can anyone tell me how to write it in MySQL v3 syntax? Thanks Daniel

select count(a.id), (a.vl)
from rqf_16_4_40_tce_test a
where a.vl < 40000
and a.id IN (select id from rqf_16_4_40_tce_test_mut b where b.region_name = 'PR' and mutation='49Y')
and a.id IN (select id from rqf_16_4_40_tce_test_mut b where b.region_name = 'RT' and mutation='45Y')
group by a.vl

 

[sleipnir214]

MySQL 3.x doesn't support subqueries.

I recommend you take a look at the MySQL online manual page on subqueries, which has information on rewriting them:

http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[r937]

[tt]select count(a.id)
, a.vl
from rqf_16_4_40_tce_test a
inner
join rqf_16_4_40_tce_test_mut b
on a.id = b.id
where a.vl < 40000
and ( ( b.region_name = 'PR' and mutation='49Y' )
or ( b.region_name = 'RT' and mutation='45Y' )
)
group
by a.vl[/tt]

rudy

http://r937.com/