join

[geebee]

hi,

i have:
SELECT DISTINCT TML.Date, TML.acd, Sites.Site AS Expr1, TML.[TML Name] AS
[TL],
StrConv(Trim(Right([full_name],Len([full_name])-InStr(1,[full_name],","))) &
" " & Trim(Left([full_name],InStr(1,[full_name],",")-1)),3) AS Agent,
TML.Acct AS [Loan Number], TML.orig_time, TML.TT, TML.HT, TML.WT,
IIf([TT]+[HT]+[WT] Between 2000 And 2999,"2000 - 2999",IIf([TT]+[HT]+[WT]
Between 3000 And 3999,"3000 - 3999",IIf([TT]+[HT]+[WT]>=4000,">=4000"))) AS
[Handle Time],
IIf([DOM_INTL_INDICATOR]="I","Offshore",IIf([DOM_INTL_INDICATOR]="D","Domestic"))
AS DOM_INTL, Contractor!FIRST_NAME & " " & Contractor!LAST_NAME AS Manager,
TML.unumNEW, Contractor.DOM_INTL_INDICATOR AS F INTO TEST_AHT
FROM TML LEFT JOIN (Hierarchy LEFT JOIN Contractor ON Hierarchy.MN =
Contractor.EN) ON TML.unumNEW = Hierarchy.EN
WHERE ((([TT]+[HT]+[WT])>=2000) AND ((Hierarchy.LEVEL)=0 Or
(Hierarchy.LEVEL) Is Null))
ORDER BY TML.[TML Name] DESC , IIf([TT]+[HT]+[WT] Between 2000 And
2999,"2000 - 2999",IIf([TT]+[HT]+[WT] Between 3000 And 3999,"3000 -
3999",IIf([TT]+[HT]+[WT]>=4000,">=4000"))) DESC;


I want to add on the Site Column of the SItes table via another/new query
(part2), joining the Location of Part2.location to the DOM_INTL_INDICATOR of
the Contractor table


thanks in advance,
geebee