Select same column multiple times with different criteria

Transact-SQL
1

Hey Guys!! I am trying to get some data from 2 tables and one of the tables, I have to pull the same column 4 times using different criteria. an example would be this.

here is what I need to pull..

Table 1 ID
Table 1 Name

Table 2 XName = RSS
Table 2 XName = PSS
Table 2 XName = JSS
Table 2 XName = XSS

I am joining the tables on the ID.

I don't know if I need to alias the fields or what. Any thoughts on how I can pull the same field 4 times if it meets certain criteria would be helpful.

2 
select t1.id, t1.name, t2.xname as rss, t2.xname as pss, t2.xname aa jss, t2.xname as xss
from table1 t1
join table2 t2 on t1.id = t2.id
3

I'm not clear on what you need. I guess something like this. Would need more details to know exactly what you need:

SELECT t1., RSS.column_name, PSS.column_name, ...
FROM dbo.table1 t1
LEFT OUTER JOIN dbo.table2 RSS ON RSS.XName = t1.Name AND t1.OtherColumn = 1
LEFT OUTER JOIN dbo.table2 PSS ON RSS.XName = t1.Name AND t1.OtherColumn = 2
LEFT OUTER JOIN dbo.table2 JSS ON RSS.XName = t1.Name AND t1.OtherColumn = 3
LEFT OUTER JOIN dbo.table2 XSS ON RSS.XName = t1.Name AND t1.OtherColumn = 4