0
Join with a constant
Hello,
In a direct query model, is it possible to have a join with a constant value ?
For e.g. can I have the join as
tableA.date = tableB.date
tableA.type = 'Type1'
another join
tableA.date = tableC.date
tableA.type = 'Type2'
Thanks
Mad
2 replies
-
Hi
You can create a custom query and build the join into it directly.
See here: Custom Query
-
Thanks Imbar, that is what I have been doing, was wondering if there was a way natively to include when I join tables in Pyramid
Thanks
Mad