How to join a table based on columns from multiple tables?
Stephen Johnson shared this question 6 months ago
I'm trying to construct a view but I'm having trouble with a simple join that involves columns from multiple tables:
SELECT * FROM TableA JOIN TableB ON TableA.col1 = TableB.col1 JOIN TableC ON TableA.col2 = TableC.col1 AND TableB.col2 = TableC.col2Is this possible with the view builder? I want to avoid using freehand SQL because that seems to throw a bunch of other YellowFin functionality out the window.