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

Hai,

I am having a query that i want to communicate two tables that
is 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 31 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 from
the 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: DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
• Prev in forum: Re: 2005 Database Mirroring & Witness
• Thread view: Communication betwee two tables

[Reply to this message]