Column 'id' in where clause is ambiguous

[kushanz]

Column 'ID' in where clause is ambiguous.when join two tables. both have save named column.

[bobbysiagian]

Please use your own id, or you can custom the sql column by using 'as' first.

[kushanz]

But I can't use aleas in where clause. That is the issue

[iMezied]

generate 'view' for your query this will solve many issues excepts performance for large dataset

[virtualgadjo]

hi, ran into the same "alert" simply solve it using mytable.id and this works for where/order and so on clauses
hope it helps