> SELECT U1.`Value` AS "First Name" , U2.`Value` AS "Last Name" , U3.`Value` AS Age , R. Registered
-> FROM `Users` U1
-> LEFT JOIN `Users` U2 ON U1.UserID = U2.UserID AND U2.FieldID = 2
-> LEFT JOIN `Users` U3 ON U1.UserID = U3.UserID AND U3.FieldID = 3
-> LEFT JOIN Registrations R ON R.UserID = U1.UserID
-> WHERE U1.FieldID = 1
-> GROUP BY U1.UserID;
+------------+-----------+------+------------+
| First Name | Last Name | Age | Registered |
+------------+-----------+------+------------+
| John | Harris | 30 | Yes |
| Amy | Ford | 35 | No |
+------------+-----------+------+------------+
2 rows in set (0.00 sec)
Just trying to help....
http://anothermysqldba.blogspot.com