Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 NSQL question

Author  Topic 

deng1974
Starting Member

1 Post

Posted - 2009-03-19 : 16:56:05
Hi Everyone,

Our company is using Clarity (a task / time management suite) and we're trying to create a report based on a nsql query.

The query needs to pull in data from a Clarity lookup table and when we use the standard table.column label it only brings back the ID of the lookup table. We need the value from that lookup table.

Any ideas on how to get the value instead of just the id.

Thanks,
   

- Advertisement -