goodmanrAy
Programmer
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
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