Re: Constraint

Here's a minor coincidence -

    Art Scott asked almost exactly the same     question at almost exactly the same time.

    Is Art Scott the same person as Alan Galvin,     or is this a piece of homework ?

I hope they are the same person, otherwise one of them doesn't seem to have read the question properly.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Alan Galvin wrote in message ...


>Suppose I have 2 tables:

>

>Team[TeamID(pk), coach, rating]

>Player[PlayerID(pk), TeamID(fk)]

>

>How do create a SQL such that a team can only have between 5 and 12

players?


>

>Thanks in advance.

>

>