Help on Join Statement

[denzlite]

Hello. I'm editing some MySQL code, here's the join:

SELECT DISTINCT l.name, l.email, l.id
FROM login AS l
JOIN revsub AS rs ON ( l.id = rs.login_id )
JOIN submissions_2008 AS s ON ( rs.sub_id = s.sub_id )
AND s.sub_id =115
ORDER BY l.name

Question: I need to make another field (subtype from table submissions_2008) available for some code below this to work. Is there a way to add another select statement into this?

Thanks!

[php_dev]

If it were me, I would use multiple tables in the FROM clause:

SELECT DISTINCT l.name, l.email, l.id, 2.field_name,2.field_name_2
FROM login AS l,
submissions_2008 AS 2

Within in the WHERE clause, manage it the same way:

WHERE 2.sub_type=1.sub_type

I hope that helps, I am just beginning to get deeper into the SQL langauge.