im not that good in SQL/sequel.. i use the SELECT in getting information from a certain table..
here is the information of the books table where i want to make some filtering:
field names: ISBN,Title,Author,Abstract,Description,Publisher, CopyRightYear,Category,UnitPrice.
the filter starts from a simple combobox wherein there are lists to choose on. aside from the combobox there are added 2 textboxes to filter more the search, like an advance search. In the filtering what i actually want to happen is that it filters the word that i have typed and displays it in a datagrid.