SELECT DISTINCT [tblWHOModelEML].[ActiveIngredient] ,[tblWHOModelEML].[Strength] ,[DosageFormRoute] ,[tblWHOATCLevelTwoCodDescrpt].[ATCLevelTwoDescript] ,[tblWHOATCLevelOneCodeDescript].ATCLevelOneDescript FROM [dbo].[tblWHOModelEML] LEFT OUTER JOIN [dbo].[tblMCAZ_Approved] ON [dbo].[tblWHOModelEML].[EMLCode] = [dbo].[tblMCAZ_Approved].[EMLCode] INNER JOIN [dbo].[tblWHOATCLevelTwoCodDescrpt] ON [dbo].[tblWHOModelEML].[ATCLevelTwoCode] = [dbo].[tblWHOATCLevelTwoCodDescrpt].[ATCLevelTwoCode] INNER JOIN tblWHOATCLevelOneCodeDescript ON tblWHOModelEML.ATCLevelOneCode = tblWHOATCLevelOneCodeDescript.ATCLevelOneCode WHERE NOT EXISTS (SELECT [dbo].[tblMCAZ_Approved].[ActiveIngredient], [dbo].[tblMCAZ_Approved].[Strength], [dbo].[tblMCAZ_Approved].[DosageForm] FROM [dbo].[tblMCAZ_Approved] WHERE [dbo].[tblWHOModelEML].[EMLCode] = [dbo].[tblMCAZ_Approved].[EMLCode]) ---AND [tblMCAZ_Approved].[Applicant] Like '%@ApplicantName%' ORDER BY ActiveIngredient
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)