Forum Discussion
Where clause that looks up values from an outside source, using Report Builder in SSRS
First off, I apologize if this is posted in the wrong place, but I didn't see anything that was dedicated to Report Builder. Secondly, I'm in Finance and understand some level of SQL reporting so pl...
Actually there are 2 ways to achieve this.
One: just join the lookup Table
Select t1.ID, t1.Field1, t1.Field2
From Table1 t1 inner join Table2 t2 on t2.ID = t1.ID
INNER JOIN Table3 T3 ON T3.Username = t2.Username
Two:
Select t1.ID, t1.Field1, t1.Field2
From Table1 t1 inner join Table2 t2 on t2.ID = t1.ID
Where t2.Username in (Select Username from table3)