Hi, I need to translate SQL below to aurelius. SELECT P1.Name, P2.Birthday, P3.Status FROM Person3 P3 LEFT JOIN Person2 P2 ON P2.Id=P1.Id LEFT JOIN Person3 P3 ON P3.Id=P1.Id WHERE P3.Status=True; NOTES: I don't need "aLotOfFields" from P1, P2, P3. I'm trying to use projections, there are ano…

projections on Multiple tables (inheritance)

wlandgraf (Wagner Landgraf) July 10, 2017, 3:26pm 2

Projections are the way to go. What did you try and what did not work, exactly?

Topic		Replies	Views
add leftJoin conditions TMS Aurelius	13	457	May 20, 2015
Mapping Person-User TMS Aurelius	10	396	July 17, 2014
Aurelius 2.9: Unexpected field type TMS Aurelius	6	451	October 13, 2015
Update different database versions TMS Aurelius	21	998	April 3, 2019
Views, Complex SQL, and Projections TMS Aurelius	1	285	September 25, 2014