Take the 2-minute tour ×

I am executing this query in FQL [@"SELECT likes,message,actor_id FROM stream WHERE source_id = %lld limit 50", _session.uid]. It is giving result well but I want to fetch my friends name also. I don't want to execute query within loop to fetch friends name from their profile. If it is possible in multiquery then which type of query I will have to write?

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

I use this code:

NSString* fql = [NSString stringWithFormat:@"SELECT uid,name FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = %lld)", session.uid];

Hope it can give you a hint.

share|improve this answer
Is it give friends name related with post or message from stream table. I am fetching message from stream table and I want to fetch name of friend. will it work ? –  Ajay_Kumar Jul 8 '11 at 9:32
I used it only for get the list of my friends after I logined.Maybe you can have a try. –  Bonny Jul 8 '11 at 9:36
@Bonny.. Yes it is working. Thanks. –  Ajay_Kumar Jul 8 '11 at 15:03
add comment

Your Answer


