Sorry, I know this is going to sound fundamental, but I just can't seem to figure it out from the manual or from an online tutorial. I have a field (x) who's value should be a flag to indicate if the value of another field 
occurs in a selection of a 3rd field (Z). Such that:
X indicates that Y occurs in the set Z.
keep in mind that these fields are nested in a much larger query and Y relate to Z through an INNER JOIN. The basic structure of the entire query is as follows:
Select Count(T1.A), Count(DISTINCT T1.B), ROUND(LOG(T1.C)), X = true if T1.Y occurs in T2.Z
FROM T1
INNER JOIN T2 ON T1.ID = T2.ID
WHERE T1.B BETWEEN D AND E
AND . . . .
AND . . .
So, I am not sure how to assemble this field or even if this is the best 'structure' for what I am trying to do. However, a push in the right direction would be much appriciated.
.
occurs in a selection of a 3rd field (Z). Such that:X indicates that Y occurs in the set Z.
keep in mind that these fields are nested in a much larger query and Y relate to Z through an INNER JOIN. The basic structure of the entire query is as follows:
Select Count(T1.A), Count(DISTINCT T1.B), ROUND(LOG(T1.C)), X = true if T1.Y occurs in T2.Z
FROM T1
INNER JOIN T2 ON T1.ID = T2.ID
WHERE T1.B BETWEEN D AND E
AND . . . .
AND . . .
So, I am not sure how to assemble this field or even if this is the best 'structure' for what I am trying to do. However, a push in the right direction would be much appriciated.
.