Hi there,
say I have 3 tables:
1. Table_empl: idEmpl, fname, lname, dob...
2. table_department: idDpartment, idEmpl, departmentName, section...
3. table_fligths: idFlight, idEmapl, departure date, destination, carrier...
I would like to provide the end-user a text box (in my GUI) where he can write whatever he would like to get info about. If, for example, he'll write: british-airways, I expect the system to search everything in the db that matches this input.
Question: How can I design such a search engine that retrieve information from every possible table in the db with reference to every column.
thanks for any pointers