jdelano/arnelgp

I am comparing the solutions you have both provided. I am in no position to judge or even comment on which is best. Only looking at them to see if I can possibly learn to fish rather that be fed fish. I can't really see why arnelgp's 3 query returns 3 records and his 4 query returns 5. jdelano, in how would your query be modified to return the same result as arnelo's query 4?

Second question. The concept of "Normalization" is a cloudy one as well. Would either of you care to comment if you feel this simple database example is "normalized"? Thank you.