Posted by lucky on 10/01/79 11:42

Hai,

I am having a query that i want to communicate two tables that
one is school table & other is class table as shown below


school table:
Class strength
LKG 30
UKG 40


class table:(LKG)


Rollno name
1 rohit
2 baba

Now my query is that as i defined strength of the LKG class as 30, if
i insert 31st in to LKG i need to get error, that not to enter. That
implies that when i am going to enter 31 student in LKG table it should
not accept asthe data corresponding to the school table.Is it possible,
if it say the coding, as i am new to SQL plz help me in coding.

thanks,
lucky.

[Back to original message]