How is this Nested Set SQL query converted into a LINQ query?

[gabrielindigo]

Querying a Nested Set Model table, here's the SQL... how can this be written in LINQ?\[code\]SELECT parent.nameFROM nested_category AS node, nested_category AS parentWHERE node.lft BETWEEN parent.lft AND parent.rgtAND node.name = 'FLASH'ORDER BY parent.lft;\[/code\]particularly, the FROM part... never tried to do anything like that in LINQ.