Re: Help with Oracle constrant on two tables problem

From: <>
Date: Mon, 18 Feb 2008 13:37:38 -0800 (PST)
Message-ID: <>

Hello David.

When I type

 ADD CONSTRAINT DI_CorrectMethodSetCount   CHECK exists (SELECT,tblt1.id1

      FROM tblT1, tblT2
       WHERE tblT1.id1 = tblT2.id1
        AND tblT1.id1 = tblt2.id1
        GROUP BY tblT1.checkCount, tblt1.id1,
         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

Original text of this message