[SOLVED] Query keeps returning NULL

[Canman2005]

Hi all

 

I am doing the following query but it keeps returning null

 

SELECT 
p.id, p.memberid 
FROM 
members_friends m 
LEFT JOIN 
members_photos_albums p 
ON 
m.friendid = p.memberid 
WHERE 
m.memberid = 11

 

Can anyone see why this might be?

 

Thanks in advance

 

Dave

[bluejay002]

maybe nothing really exists...

 

if it did exist, can you post the sample table content.

[Canman2005]

HAHA, yes im a plonker, the data didnt exist with the correct fields

 

Thanks