hi,
i am facing a small problem
there are 2 tables

table1

tran
-------
a/ctype
openbalance
name
a/cno


table two
restr
------
a/c type
minbalance
maxbalance


how will i put a check constraint in the create command of table1(tran) such
that depending on the a/c type the openbalance
should be greater than the minbalance of that a/ctype which we get from table2(restr)

create table tran
(
...
)
please help!!!!!!!!!!

Santosh