Joining 2 tables with 'Soft Delete' enabled on both tables

Topic: Joining 2 tables with 'Soft Delete' enabled on both tables (Read 1631 times) previous topic - next topic

Joining 2 tables with 'Soft Delete' enabled on both tables

June 12, 2020, 12:53:19 PM

database: MySQL (have not tested with other databases)
List form: when joining 2 tables with 'Soft Delete' enabled on both tables I get this error:
Column 'is_deleted' in where clause is ambiguous

Re: Joining 2 tables with 'Soft Delete' enabled on both tables

Reply #1 – June 12, 2020, 01:22:23 PM

I am thinking that you'll get that error if any columns between the two tables match.. Instead of the SQL Statement being "Select *" it should list the columns and preface each by the table name. Hopefully PHPRad can make that change in the next release..