Thanks. I got the answer for the join. My second part was is that there any api anyways that we can execute query directly On 06-Dec-2015 17:09, "Kasper Sørensen" <[email protected]> wrote:
> Well, a first-class join is also possible. Just use the query API... I'm > not even sure what the question is here Arunkumar?? > > 2015-12-05 23:41 GMT+01:00 Tomasz Guziałek <[email protected]>: > > > Hello Arunkumar, > > > > MetaModel does not have specialialized constructs for JOIN operations. > Try > > writing your query in such a manner: > > > > > > > dataContext.query().from("tableA").and("tableB").selectAll().where("joinColumnFromA").eq("joinColumnFromB").executeQuery(); > > > > Pozdrawiam / Regards / Med venlig hilsen > > Tomasz Guziałek > > > > 2015-12-04 11:19 GMT+01:00 Arunkumar Pillai <[email protected]>: > > > > > Please help in executing the following queries > > > > > > SELECT a.id as ID, > > > a.a_name as a_NAME ,b.user_name > > > FROM TB_a a inner join TB_b b on b.id = a.id > > > WHERE a.active = 1 > > > > > > > > > I'm not finding any examples for joins > > > or directly converting the sql queries to meta model query > > > > > > -- > > > Thanks and Regards > > > Arun > > > > > >
