I am fetching data from two table to my view using View API. How can I add where clause to my view?
My actual SQL query is like:
select field1,field2,field3,t2field4 from table1,table2 where t2field=field1
I come across hook_view_alter() but I dont know how to implement that. Can I use any filter handler in my views.inc file?