search

IgnitedDatatables / Ignited-Datatables

Ignited Datatables is a wrapper class/library based on the native Datatables server-side implementation by Allan Jardine found at http://datatables.net/examples/data_sources/server_side.html for CodeIgniter
285 stars 337 forks source link

Column 'id' in where clause is ambiguous #119

Open kushanz opened 7 years ago

kushanz commented 7 years ago

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

bobbysiagian commented 7 years ago

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

kushanz commented 7 years ago

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

iMezied commented 7 years ago

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

virtualgadjo commented 6 years ago

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