I want to query my database and get the suburb, region, email and created date for users in a list. I've copied two queries I know work:
______________
select
us.firstname as [First Name],
us.lastname as [Last Name],
us.email as [Email],
up.createddate as [Entry Date]
from users us
inner join userportals up on us.userid=up.userid
where up.portalid=0
_____________

and:
_____________
SELECT DISTINCT
  u.LastName AS [Last Name],  u.FirstName AS [First], upd.Profession, upd.Region, u.Email
FROM dbo.Users as u INNER JOIN
  dbo.UserRoles AS ur ON u.UserID = ur.UserID
INNER JOIN Roles R on UR.Roleid = R.Roleid
INNER JOIN
  (SELECT      
    up.UserID,  
    MAX(CASE WHEN ppd.PropertyName = 'Profession' THEN up.PropertyValue ELSE '' END) AS Profession,
    MAX(CASE WHEN ppd.PropertyName = 'Region' THEN up.PropertyValue ELSE '' END) AS Region
   FROM           
    dbo.UserProfile AS up INNER JOIN 
    dbo.ProfilePropertyDefinition AS ppd ON up.PropertyDefinitionID = ppd.PropertyDefinitionID AND ppd.PortalID = 0 
   GROUP BY up.UserID) AS upd ON u.UserID = upd.UserID
_____________

and tried to merge them into:

SELECT DISTINCT
  u.LastName AS [Last Name],  u.FirstName AS [First], upd.Profession, upd.Region, u.Email, up.createddate
FROM dbo.Users as u INNER JOIN
  dbo.UserRoles AS ur ON u.UserID = ur.UserID INNER JOIN
users us
INNER JOIN userportals up on us.userid=up.userid
INNER JOIN Roles R on UR.Roleid = R.Roleid
INNER JOIN
  (SELECT      
    up.UserID,  
    MAX(CASE WHEN ppd.PropertyName = 'Profession' THEN up.PropertyValue ELSE '' END) AS Profession,
    MAX(CASE WHEN ppd.PropertyName = 'Region' THEN up.PropertyValue ELSE '' END) AS Region
   FROM           
    dbo.UserProfile AS up INNER JOIN 
    dbo.ProfilePropertyDefinition AS ppd ON up.PropertyDefinitionID = ppd.PropertyDefinitionID AND ppd.PortalID = 0 
   GROUP BY up.UserID) AS upd ON u.UserID = upd.UserID 

but it says I have an incorrect syntax on line 16 near 'UserID'. (what ever I leave as the end, it says the error is there. Ie: If I delete everything after '0', it says the syntax error is at line 0.

I'm a total noob, I'm just trying to make these queries work using my limited knowledge. Can anyone give me a fix, and even better, explain why the fix works?

Thanks!

Thanks for your reply Sebastian. It still tells me 'There was an error executing the data source: There is an error in your SQL at line 6: Incorrect syntax near the keyword 'WHERE'. '. I've looked up the property definitiion ids and entered them (17 becomes 9 and 33 becomes 56) Is there anything else I can try? (I tried deleting line 6 - no joy).