subquery error with no result

[sangprabv <sangprabv@xxxxxxxxx>]

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