Added by ronald viscarra about 10 years ago
hi, having
A that belongs to B
how can I achieve a query as:
SELECT A.* FROM A INNER JOIN B ON A.B_id=B.id WHERE B.id=10 ORDER BY B.name ASC
?
I'm interesting in the way to pass params to the related objects.
Thanks in advance.
Hey,
That would be something like session.query<dbo::ptr>("select a from A a inner join B b on a.B_id=b.id WHERE b.id=10 ORDER BY b.name ASC");
Regards,
koen