I have a jqgrid having 4 coulumns from two different tables (eg. tableA,tableB).I want to perform a complex searh on the coulums of both tables.I find that the search feature is currently supports only single table search.Can anyone please let me know how to form a query in jqgrid of multiple columns of multiple table.

I need to form a query somthing like this using jQgrid.

Select  a.user_id,a.user_name,b.location_id,b.location_name from tableA a ,tableB b where a.location_id=b.location_id

Please let me know if this can be a accomplished using jQgird.Your help is greatly appriciated.

Thanks,

Bosco