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" <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
