CODEWITHSUNDEEP
c#sqlsubsonicinner-join
Pieter Taelman
Pieter Taelman

Reputation: 1

Can you do an inner select with Subsonic?

This is my sql query: subsonic version 2.1.0.0 No Linq (.net 2.0)

select
(
  select Title from MenuTranslation mnu2 where
  mnu2.languageid = 1 and mnu2.menuelementid = menutranslation.menuelementid
)as BaseTitle, *
from menutranslation
inner join menuelement on menuelement.id = menutranslation.menuelementid
where menuelementid
in (select id from menuelement where parentid = 4)
and languageid = 2

Upvotes: 0

Views: 213

Answers (2)

runxc1 Bret Ferrier
runxc1 Bret Ferrier

Reputation: 8233

You would need to use the inlineQuery class where you generate the sql yourself to accomplish what you are going after

Upvotes: 0

user1151
user1151

Reputation:

Not at this time - however you can run IN queries with a SELECT - not subqueries however.

Upvotes: 1

Related Questions