Re: "SELECT IN SELECT" problem in MySQL
Why not save yopurself a lot of trouble and use a JOIN
SELECT e.rsa_eventNature_id
, e.rsa_eventNature_name
FROM rsa_eventnature e
JOIN rsa_policy_plan_lookup p
ON p.rsa_lookup_id = e.rsa_eventnature_id
WHERE p.ras_plan_id = 1;
or something like that.
Good luck,
Barry.
Subject
Written By
Posted
September 19, 2014 08:36AM
September 19, 2014 02:55PM
September 21, 2014 08:52PM
September 22, 2014 09:48AM
September 23, 2014 05:07AM
Re: "SELECT IN SELECT" problem in MySQL
September 21, 2014 09:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.