I am struggling with building queries with derived tables. can someone give me some insight into this. I want to use the design view to do this, since I am not good at understanding the sql statements. Most of the postings on the web show you how to do this with sql statements. I would like to know how to do this in visual studio, in diagram using the query builder when connecting to an sql server.