Linq assign values from one table into another
===

I am trying to lookup a value of an column from another table and later use the new looked up values in my where clause. For example, I have the following tables below

    ID    Name
     1     Jan
     2     Feb
     3     March

    Product    Customer  Start   End
      A          C        Feb    March
      A          B        Jan    March
      B          C        March  Jan

In the example above, I need to query for the list of records where Start ID is greater than the End ID. For example,  B-C-March-Jan is the record I am looking for.
Should I be using join? Also, if possible a query syntax would be very helpful.

Thanks