How Can I make a left join in qcode/qcubed and select fields from both tables. ( no FK exists but there are fields that are logical to join ).
Asked
Active
Viewed 162 times
1 Answers
2
You can define foreign key relationships without explicit foreign keys in the database - see http://examples.qcu.be/assets/_core/php/examples/code_generator/script_path.php.
If the above is not possible, I'd write a custom SQL query in that case.
Alex Weinstein
- 9,823
- 9
- 42
- 59