CODEWITHSUNDEEP
reporting-services
BenGC
BenGC

Reputation: 2854

SQL Server Reporting Service - Reference another dataset?

I have two datasets in a SQL Server 2008 reporting services report. I need to attach a WHERE clause to the second one that will contain a value from the first one. How should I write that second query?

Upvotes: 1

Views: 1286

Answers (1)

lockdown
lockdown

Reputation: 1496

If I understand what you are asking, you should run a SUB query within the where clause.

SELECT title FROM books WHERE author_id IN (SELECT id FROM authors);

Upvotes: 1

Related Questions