Thread: newbie
View Single Post
  #31 (permalink)  
Old 08-30-10, 23:23
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
Quote:
Originally Posted by twinkiejr View Post
If I understand correctly I will have to combine the three to create the unique combinations.
i don't know if you will have to or not -- maybe they're a hierarchy

could you please do a SHOW CREATE TABLE for the year, category, type tables (i want to see the latest versions)

please include a few sample rows of each again
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote