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

null
    • imbarmarinescubar_pyram
    • 2 wk ago
    • Reported - view

    Hi 
    You can create a custom query and build the join into it directly.
    See here: Custom Query
     

    • Mad_Amruthur
    • 2 wk ago
    • Reported - view

    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

Login to reply

Content aside

  • Status Answered
  • 2 wk agoLast active
  • 2Replies
  • 33Views
  • 2 Following