Okay, I'm really stumped on this one. Hopefully I can explain this rather painfully. I'm trying to write a function that gets the top ten software titles that appear the most in "two" different tables. There are 4 tables that have the info I need: TradeWant, TradeHave, HaveList, and Software.
Software contains two relevant fields sw_id, and name. TradeWant is linked to it through TradeWant.sw_id = Software.sw_id. TradeHave is a bit tricker. It is connected to HaveList by TradeHave.have_id = HaveList.have_id and then to Software by HaveList.sw_id = Software.sw_id.
So basically I need to get counts of the software titles that appear the most, combining the totals in both the TradeWant and TradeHave tables.
Is this even possible? Any help would be very appreciated. Thanks.
