Linq Query

[shapper]

Hello,

I have two tables, Tags and ArticlesTags, with the following columns:

Tags TagID, Text

ArticlesTags TagID, ArticleID

I need to create a LINQ query to select all records in Tags which are
also in ArticlesTags. I have the following:

Dim database As New CodeDataContext

Dim tags = From t In database.Tags _
Select t.TagID, t.Text _ ???

How would I do this?

Thanks,

Miguel