Searching for keyword across 3 tables
I have three tables with similar structure but different column names:
Shopping1
- one_id(int unsigned)
- product(varchar)
- price(float unsigned)
Shopping2
- two_id(int unsigned)
- product_name(varchar)
- price(float unsigned)
Shopping3
- three_id(int unsigned)
- product(varchar)
- retail_price(float unsigned)
I want to search for a keyword on the product or product_name across all three tables along with sorting by price or retail_price. What's the best sql way to solve this?
Subject
Written By
Posted
Searching for keyword across 3 tables
March 05, 2009 01:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.