Re: subquery error with no result

[David Lazo <lazo.david@xxxxxxxxx>]

Would this work for you?

SELECT msgdata 
FROM sent_sms 
WHERE momt = 'MT'
AND binfo IN (SELECT
        binfo 
        FROM sent_sms
        WHERE momt = 'DLR')


David 


On 5/21/08 10:30 PM, "sangprabv" <sangprabv@xxxxxxxxx> wrote:

> Hi,
> I tried to look for records from a table with this query:
> SELECT msgdata FROM sent_sms WHERE momt = 'MT'AND binfo = (  SELECT
> binfo FROM sent_sms WHERE momt = 'DLR' )
> But MySQL returns this error:
> #1242 - Subquery returns more than 1 row
> I tried also with ANY, IN, EXISTS.
> And modified the query into:
> SELECT t1.msgdata FROM (SELECT binfo FROM sent_sms WHERE momt = 'DLR') AS t1
> WHERE momt = 'MT'. But none works.
> What I want to view is, all records which has momt = 'MT' and binfo from
> the same table where has momt = 'DLR' and has the same binfo. TIA
> 
> Regards,
> 
> 
> Willy
> 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx