[seijurojushi]

Hello fellow DIC members!
My head is cracking trying to figure out how to query this.
I have a table containing information relating to the Star Wars movies.
The table has character names, planet names, movie numbers and arrival and departure times showing when the specified character visited a planet.

What I need to get is the characters that have been on the same planet at the same time during the same movie based on the arrival and departure time.

First of all it's difficult enough for me to imagine how to find the characters that have been on the same planet at the same time, but when I think about displaying an arbitrary number of names my brain crashes...

If someone could point me in the right direction logic wise, would be great, I just don't know how to go about it.

[coder3788]

LINQ query samples :
http://code.msdn.mic...amples-3fb9811b

edit : sorry wrong link the first time

This post has been edited by coder3788: 10 November 2012 - 06:17 AM