Re: Help with Oracle constrant on two tables problem
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Tue, 19 Feb 2008 02:05:01 -0800 (PST)
Message-ID: <a868c376-1792-409b-80cc-d34f49a9e790@62g2000hsn.googlegroups.com>
Date: Tue, 19 Feb 2008 02:05:01 -0800 (PST)
Message-ID: <a868c376-1792-409b-80cc-d34f49a9e790@62g2000hsn.googlegroups.com>
On Feb 18, 10:37 pm, jharbo..._at_googlemail.com wrote:
> 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
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/data_int.htm#sthref3116
robert Received on Tue Feb 19 2008 - 04:05:01 CST