MySQL join empty rows?

SELECT * FROM wp_sb_users you LEFT OUTER JOIN wp_sb_usermeta m ON (u. ID=m. User_id and m.

Meta_key = "autostatus") LEFT OUTER JOIN wp_sb_usermeta mm ON (u. ID=mm. User_id and mm.

Meta_key = "first_name") LEFT OUTER JOIN wp_sb_usermeta mmm ON (u. ID=mmm. User_id and mmm.

Meta_key = "last_name").

You know what, I just tried that and it worked! Seems like WHERE is kinda strict for selects, and putting conditions in ON is more loosy – Alex Jun 1 at 8:58 Your meta_key is part of your join criteria. If you do your original query without your WHERE clause, you'll realise what the dataset you were filtering looked like.

– Steve Mayne Jun 1 at 10:22.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions