I opened an asp.net project with this query inside of an `aspx.cs` file:

```
from ev in table1
where ev.FromDate > DateTime.Today && ev.Active
orderby ev.FromDate
select ev;

```

This automatically turned into an array.

I'm a newby to asp.net. It's probably very easy but I can't figure how to add another table (table2) and conditions into this!

You would probably ask for the table structure, it's something like:

**table1** 

```
event_id  
FromDate  
toDate  
*item_id* [should be used as foreign key]  
Active  

```

**table2** 

```
item_id [should be used as foreign key]  
Desc   
Lang   
Active  

```

Thank you