The query here, is getting the first verse of all chapters from a book in a bible. SELECT First(t.textid) AS FirstOftextid, First(bookch.chapter) AS FirstOfchapter FROM bookchapter AS bookch INNER JOIN bookchapteralinea AS bca INNER JOIN [Text] AS t ON bca.bookchapteralineaid = t.BookChapterAlineaid AND bca.Alineaid = t.Alineaid ON bookch.bookchapterid = bca.bookchapterid WHERE t.bookeditionid=? GROUP BY bca.bookchapterid; In LINQ I could produce something like this (but no further). Who can help
Read More...