I received the following error trying to do this query
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting from a character string to uniqueidentifier.
SELECT DisplayName, UserGUID FROM Profiles, Requests WHERE Profiles.UserGUID = Requests.UserGUID
The UserGUID field of the table Profiles is type uniqueidentifier
The UserGUID field of the table Requests is type nvarchar(100)
I can't change the type of those fields for technical reasons.
Could you help me building the right SQL query ?