Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Re: [KJones] help with SQL statement

May 29, 2003, 8:37 PM
brose
New User (2 posts)
May 29, 2003, 8:37 PM
Views: 4764
Shortcut
Quote Reply
Re: [KJones] help with SQL statement In reply to
One of your problems might be that that's a confusing table. If MIN_UNITS applies to the minimum units for a given CATEGORY, then how can row one have "elective 40" and the next have "elective 24"? Which MIN_UNITS is valid?

It seems like the first task is to normalize the tables a bit more. Or, I may just be confused by your question.
Subject Author Views Date
Thread help with SQL statement KJones 4972 May 25, 2003, 3:48 PM
Post Re: [KJones] help with SQL statement 		604 4771 May 26, 2003, 9:38 AM
Post Re: [KJones] help with SQL statement 		brose 4764 May 29, 2003, 8:37 PM