Re: Help with Oracle constrant on two tables problem
From: <jharbour7_at_googlemail.com>
Date: Mon, 18 Feb 2008 13:37:38 -0800 (PST)
Message-ID: <bfdbfaf6-3a2c-427d-84a8-5f165689d751@s19g2000prg.googlegroups.com>
Date: Mon, 18 Feb 2008 13:37:38 -0800 (PST)
Message-ID: <bfdbfaf6-3a2c-427d-84a8-5f165689d751@s19g2000prg.googlegroups.com>
Hello David.
When I type
ALTER TABLE tblT2
ADD CONSTRAINT DI_CorrectMethodSetCount
CHECK exists (SELECT tblt2.id,tblt1.id1
FROM tblT1, tblT2 WHERE tblT1.id1 = tblT2.id1 AND tblT1.id1 = tblt2.id1 GROUP BY tblT1.checkCount, tblt1.id1, tblt2.id HAVING COUNT(*) = tblT1.checkCount-1);
my error is
ORA-00906: missing left parenthesis
Thank you
Jon
Received on Mon Feb 18 2008 - 15:37:38 CST