Linq to Sql Filtering child table

[Benny]

I am trying to select certain data from a parent table, but would like
to constrain the results based on the child tables attributes. The
relationship is a one to many so if i try to specify a filter for the
child table, i unable to access the child attributes. Does anyone
have any ideas on how i might be able to do this?

An example of the relationship is below:

Country
-----------
CountryId
Name

State
-------
StateId
CountryId
Name
Population

I want to select only States with city populations greater than
50,000.

Thanks in advance!
Ben

 

[Cowboy \(Gregory A. Beamer\)]

One SQL Query might look like this:

SELECT * FROM State
WHERE StateID IN (SELECT DISTINCT StateID FROM City WHERE Population >
50000)

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************