MySQL Multiple Join/Subquery Questions?

SELECT u. User_id, u. Username, u.

Email, IF(t1. User_id IS NULL, 0, 1) AS Exists_in_Table1, IF(t2. User_id IS NULL, 0, 1) AS Exists_in_Table2, IF(t3.

User_id IS NULL, 0, 1) AS Exists_in_Table3 FROM Users you LEFT OUTER JOIN Table1 t1 USING (User_id) LEFT OUTER JOIN Table2 t2 USING (User_id) LEFT OUTER JOIN Table3 t3 USING (User_id).

Thank you for this, such a fast response! I'll be trying this as soon as I'm back at the office. – Johnny B Dec 27 '09 at 8:12.

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.