Code:
	SELECT 
		Guid
	FROM
		ContactsPermissions
	WHERE ContactsPermissions.ContactGuid = @ContactGuid
	AND @ZoneName = (SELECT 
						SecurityZones.Name 
					FROM 
						SecurityZones 
					WHERE 
						SecurityZones.Guid = ContactsPermissions.SecurityZoneGuid)
^ Does not work.

Code:
SET @ZoneGuid = (SELECT Guid FROM SecurityZones WHERE SecurityZones.Name = @ZoneName)

SELECT Guid FROM ContactsPermissions 
WHERE ContactsPermission.ContactGuid = @ContactGuid
AND @ZoneGuid = ContactsPermissions.SecurtyZoneGuid
^ Will not save.

I'm trying to load a contact permission based on the contact guid and the name of the security zone. The name is unique and returns one result when you pull it by name. The Permissins pulls all permissions fine by ContactGuid.

ContactPermissions
---------------------------------------------------------------------------------
3 Guid uniqueidentifier 16 0
0 ContactGuid uniqueidentifier 16 0
0 SecurityZoneGuid uniqueidentifier 16 0

SecurityZones
---------------------------------------------------------------------------------
3 Guid uniqueidentifier 16 0
0 Name varchar 300 0
0 Description text 16 1

Code:
	SELECT     ContactsPermissions.Guid
	FROM         ContactsPermissions INNER JOIN
	                      SecurityZones ON ContactsPermissions.SecurityZoneGuid = SecurityZones.Guid
	WHERE  (ContactsPermissions.ContactGuid = @ContactGuid)
	AND    (SecurityZones.Name = @ZoneName)
^ Returns nothing even when passed valid param.

So basicly I know the contact, I know the Zone name and I need to get the Permission guid.

Thanks to anyone who can help.