BACKGROUND
Some profiles are people; some profiles are locations.
'People' work at 'locations'

Using CB Connections, People connect to Locations and designate a connection type of "Works At"

I want to show a line in people's profiles ...
'Fred' -- 'works at' -- 'Factory A'
Loged in User -- Connection Type -- A Different User ID's Name

After reading through the tutorials from Kyle's signature, I learnt about Substitutions

The logged in user Fred [cb:userdata field="username" user="#me" /] works at [cb:userdata field="name" user="99" /].
Where 99 is Factory A.... I just have to make that user="99" 'dynamic'

Next I read about CB Query Fields, so after much fiddling in mysqladmin, I came up with this (I am very new to SQL)
SELECT memberid
FROM `mydb_comprofiler_members`
WHERE `type` = 'Works at'
AND `referenceid` = '[user_id]'

This gave me the id number of the target location. I tested it as
Works At = [cb:userdata field="cb_worksat" /]
logged on as different users, and the number changed appropriately.

For the last step, I tried
The logged in user Fred [cb:userdata field="username" user="#me" /] works at [cb:userdata field="name" user="cb_worksat" /].
But this did not work. A blank was displayed.

I guess that cb_worksat is not resolving to a number??
I played around some more with syntax guessing but wih no luck... Sorry for the long description, but I have tried to get as far as I can by myself.

But if someone could help me along the rest of the way, that would be much appreciated.

Thank You for that explanation. That makes sense now.
And also many thanks for taking the trouble to write out that SQL query. The extra time and thought for this is much appreciated.
Kind Regards,
PT

This works fine.

Is there any way to get the name of the displayed connection as a link to the profile ?

Not: User Fred works at Factory A

But: User Fred works at Factory A

Hrrrrr... It works.

Thank you so much.