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.

• Next in forum: Re: Communication betwee two tables
• Prev in forum: DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
• Thread view: Communication betwee two tables

[Reply to this message]