CREATE TABLE [dbo].[A] ([AID] [int] NOT NULL ,[Name] [varchar] ( 50 ),[Country] [varchar] ( 50 )) ON [PRIMARY]
CREATE TABLE [dbo].[R]([RID] [int] NOT NULL ,[Title] [varchar] ( 50 ),[Journal] [varchar] ( 50 )) ON [PRIMARY]
CREATE TABLE [dbo].[R_A] ([AID] [int] NOT NULL ,[RID] [int] NOT NULL) ON [PRIMARY]
ALTER TABLE [dbo].[A] ADD CONSTRAINT [PK_A] PRIMARY KEY  CLUSTERED ([AID])  ON [PRIMARY] 
ALTER TABLE [dbo].[R] ADD CONSTRAINT [PK_R] PRIMARY KEY  CLUSTERED ([RID])  ON [PRIMARY] 
ALTER TABLE [dbo].[R_A] WITH NOCHECK ADD CONSTRAINT [PK_R_A] PRIMARY KEY  CLUSTERED([AID],[RID])  ON [PRIMARY] 
ALTER TABLE [dbo].[R_A] ADD CONSTRAINT [FK_R_A_A] FOREIGN KEY ([AID]) REFERENCES [dbo].[A]([AID]),
			    CONSTRAINT [FK_R_A_R] FOREIGN KEY ([RID]) REFERENCES [dbo].[R] ([RID])			    
			    
INSERT A VALUES ( 1 , 'A', 'A')
INSERT A VALUES ( 2 , 'B', 'B')
INSERT A VALUES ( 3 , 'C', 'C')
INSERT R VALUES ( 1 , '1', '1')
INSERT R VALUES ( 2 , '2', '2')
INSERT R VALUES ( 3 , '3', '3')
INSERT R_A VALUES ( 1 ,  1 )
INSERT R_A VALUES ( 1 ,  2 )
INSERT R_A VALUES ( 2 ,  1 )
INSERT R_A VALUES ( 2 ,  3 )
INSERT R_A VALUES ( 3 ,  3 )

SELECT DISTINCT A.Country
FROM  A INNER JOIN
               R_A ON A.AID = R_A.AID INNER JOIN
               R ON R_A.RID = R.RID
WHERE (A.Country IN ('A', 'B')) AND (R.Journal IN ('1', '2', '3'))

SELECT DISTINCT dbo.R.Journal
FROM  dbo.A INNER JOIN
               dbo.R_A ON dbo.A.AID = dbo.R_A.AID INNER JOIN
               dbo.R ON dbo.R_A.RID = dbo.R.RID
WHERE (dbo.A.Country IN ('A', 'B', 'C') AND dbo.R.Journal IN ('1', '2', '3'))               

SELECT DISTINCT dbo.R.Journal
FROM  dbo.A INNER JOIN
               dbo.R_A ON dbo.A.AID = dbo.R_A.AID INNER JOIN
               dbo.R ON dbo.R_A.RID = dbo.R.RID
WHERE (dbo.A.Country IN ('A', 'B')) AND (dbo.R.Journal IN ('1', '2', '3'))

SELECT DISTINCT dbo.A.Country
FROM  dbo.A INNER JOIN
               dbo.R_A ON dbo.A.AID = dbo.R_A.AID INNER JOIN
               dbo.R ON dbo.R_A.RID = dbo.R.RID
WHERE (dbo.A.Country IN ('A', 'B')) AND (dbo.R.Journal IN ('1', '2', '3'))

  
SELECT DISTINCT Country FROM #MyTable
SELECT DISTINCT Journal FROM #MyTable
etc.

   Select DISTINCT Journal from ViewOUT where 
    WHERE (Country IN ('A', 'B')) AND (Journal IN ('1', '2', '3'))
  

CREATE TABLE [dbo].[Reference_User]([ReferenceID] [int] NOT NULL, [UserID] [int] NOT NULL) ON [PRIMARY]

SELECT DISTINCT dbo.R.Journal
FROM         dbo.A INNER JOIN
                      dbo.R_A ON dbo.A.AID = dbo.R_A.AID INNER JOIN
                      dbo.R ON dbo.R_A.RID = dbo.R.RID LEFT OUTER JOIN
                      dbo.Reference_User ON dbo.R.RID = dbo.Reference_User.ReferenceID
WHERE     (dbo.A.Country IN ('A', 'B')) AND (dbo.R.Journal IN ('1', '2', '3')) AND 
          (dbo.Reference_User.ReferenceID =  133  OR dbo.Reference_User.ReferenceID IS NULL))) 

 
 SELECT DISTINCT dbo.R.Journal
FROM         dbo.A INNER JOIN
                      dbo.R_A ON dbo.A.AID = dbo.R_A.AID INNER JOIN
                      dbo.R ON dbo.R_A.RID = dbo.R.RID LEFT OUTER JOIN
                      dbo.Reference_User ON dbo.R.RID = dbo.Reference_User.ReferenceID
WHERE (dbo.A.Country IN ('A', 'B')) AND (dbo.R.Journal IN ('1', '2', '3')) AND     
(dbo.Reference_User.UserID =  133 ) OR (dbo.Reference_User.UserID IS NULL)

SELECT DISTINCT dbo.R.Journal
FROM  (select AID from dbo.A where Country='A' OR Country='B') a INNER JOIN