is it possible to perform a search across multiple tables in a database. i.e. Search through orders based on customer details or items bought. Customer details are in transactions table and products purchased in orderline table.
