Dear Awanvil,

    As SEQUEL Terminology Concerns,You can not have any reference to other table unless untill u join the both table.

You can write in this manner....

Select StatusXref .Status

 From StatusXref  INNER JOIN...

Yes My Dear While visiting this I found out ur query first and go through that.

I am sure u can declare a viable like before select statement or you can...