Select with If? 1

[goodmanrAy]

Hello

I am unsure if this is possible, but I'll give it a bash.

I have a query

select MML.ChangeID,MCCTT.ChangeToDesc
from MaceMaterialLog MML
Left Outer Join MaceChangesLog MCL on MML.ChangeID = MCL.ChangeID
Left Outer Join MaceChangesChangeToTypes MCCTT on MCL.ChangeToID = MCCTT.ChangeToID
where MML.MaceID = '69306'

if for example I return 'Other' in the MCCTT.ChangeToDesc field, is it possible to get another value from another table using MML.ChangeID. All in the same query.


Cheers in advance

Andrew

 

[SQLSister]

Look up the Case statment in BOL

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[goodmanrAy]

Thanks

That did the trick



Andrew