Set Column Alias In Searching

[C.S.PuteraParticipant]

Hello. I am using jqxgrid to display data. My query is this :

SELECT item.item_name, supplier.company_name AS supplier_company_name
FROM tbl_item item LEFT JOIN tbl_supplier supplier ON item.supplier_id = supplier.supplier_id;

Now, if I search using text field on column Supplier Name, it will generate error saying :

Unknown column ‘supplier_company_name ‘ in ‘where clause’

How to set column alias name for the grid ? Thank you

[Author]

Posts