> On an entry not all fields of the four quarter fields are covered with > values. Following combinations are possible:
Why don't you just use one extra column (apart from whatever other data you are storing) with that column being a date field. Then, you can determine what data is part of what time period as part of the query. Perhaps I'm not understanding what your ultimate need is, but I don't see any reason why you would need a schema such as the example you provided or 15 extra tables. Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]