metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kasper Sørensen <i.am.kasper.soren...@gmail.com>
Subject Re: How to use joins using apache meta modes
Date Sun, 06 Dec 2015 11:39:41 GMT
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 <tomasz@guzialek.info>:

> 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 <arunkumar1111@gmail.com>:
>
> > 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
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message