Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

create joins with conditions other than column equality?

April 26, 2017column Conditions create equality joins

0

Posted

create joins with conditions other than column equality?

1 Answer

0

Posted

Currently, DBIx::Class can only create join conditions using equality, so you’re probably better off creating a view in your database, and using that as your source. A view is a stored SQL query, which can be accessed similarly to a table, see your database documentation for details.