sql exist

Posted on

SQL

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT Email from [MicroAnalytix].[dbo].[Customer] where Id  
  in( select Customer_Id From [MicroAnalytix].[dbo].[Customer_CustomerRole_Mapping] where CustomerRole_Id=6);