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
>
