I have a simple SQL query that returns a value in Host/SQL but none when I use a Token in Tailored Text SQL. How is this intended to work? I cannot find an actual example in the docs for Tailored Text, the example uses a query string.

Token for is $(CompanyName)

Token Key
SELECT Contacts.[CompanyName]
FROM {objectQualifier}xxxxx_ContactDetail As Contacts
WHERE Contacts.[UserName] = $(UserName)

I've tried variations on the token as variable syntax such as [UserName], '$(UserName)'
Also tried to match on UserID

This is with Tailored HTML v 2.10.21 on DNN 5.1.1

David thanks for your response...

I tried $(UserID) in my query and it did not work...

But

SELECT Username
FROM {objectQualifier}Users
WHERE UserID = $(UserID)

works fine.

The example query in my original post does not show I have to use 3 tables to get user's Company Name to display from UserID

table1 CompanyDetails contains Company Name, CompanyID
table2 ContactDetails contains Username, CompanyID
table3 Users contains Username, UserID

Is there some limit to the query that can be used? 
I've read suggestions from Chad to use SProcs for this but don't know how. Is there an example for using stored procedures in the module's SQL token key?

David,

Your suggestion did not work but showed me some things that when tweaked gave me the result I was looking for.

Here is what finally worked:
select {objectQualifier}CompanyDetail.[CompanyName] as Company from {objectQualifier}CompanyDetail inner join {objectQualifier}ContactDetail on {objectQualifier}CompanyDetail.[CompanyID] = {objectQualifier}ContactDetail.[CompanyID] inner join {objectQualifier}Users on {objectQualifier}ContactDetail.[Username] = {objectQualifier}Users.Username where {objectQualifier}Users.UserID = '$(UserID)'

Possibly not the most concise, but I've got what I need!!!

Thanks again