ekmungai / eloquent-ifrs

Eloquent Double Entry Accounting with a focus on IFRS Compliant Reporting
MIT License
332 stars 67 forks source link

Specify entity_id table in joins #166

Closed marvoh closed 2 months ago

marvoh commented 2 months ago

When you perform join queries between two tables which have the entity_id column e.g. Account and Currency to display currency name, the injected where entity_id = 7 leads to an ambiguous column error.

This patch tries to address this challenge by being specific about which table column to reference.