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 > > >
