Thread: newbie
View Single Post
  #11 (permalink)  
Old 08-27-10, 17:04
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
Quote:
Originally Posted by twinkiejr View Post
... so that I can not enter a year that does not match a type and a type that does not match a category
this is the part that i don't understand

how can a year match a type and a type match a category?

is that what the year_variety table is supposed to be doing for you?

could you please mysqldump a few rows from that table
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote