Select in Select using Uniqueindentifier as the key
Posted on 2006-04-20
I have 2 tables, adxprofile is the main table, adxProfileValues is the child table.
They are joined by a field called adxProfileGuid.
I want to query send the query the userkey which is the username.
The query then in turn needs to return all the child rows with the matching uniqueindentifier
I have the following statement
where userkey = 'john'
and adxProfileGuid =
When I use = I get this error
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
When I use IN instead of = I get this error
Syntax error converting from a character string to uniqueidentifier.