0

I am using following query to retrieve a single record from the ymail.messages table -

select message from ymail.msgcontent where (fid,mids) in (select folder.folderInfo.fid,
mid from ymail.messages where query="Yahoo" and mid="-----" limit 1)

but I am not able to get a single record instead of that I am getting bunch of records.

what modifications in above query will get a single record?

Infinite Recursion
  • 6,511
  • 28
  • 39
  • 51
Nil
  • 1
  • 1

1 Answers1

-1

Change to:

select message
from ymail.msgcontent
where (fid,mids) in (
    select folder.folderInfo.fid, mid
    from ymail.messages
    where query="Yahoo" and mid="-----" | truncate(count=1))
Mihai Maruseac
  • 20,967
  • 7
  • 57
  • 109
user3200528
  • 63
  • 1
  • 1
  • 8