From: mcstockX@Xenquery   
      
   "ERD"  wrote in message   
   news:Xns9574AEB351DD0glnospamnet@216.196.97.131...   
   | Yes I finally figured out the cascade constraints.   
   | Thanks for that select statement.   
   |   
   | Question: does this imply that the RI in the relationship was not defined   
   | correctly?   
   |   
   |   
   |   
      
   not at all -- its not abnormal to need to use cascade constraints option if   
   FKs still exist, and its not abnormal if a table in another schema has FK   
   constraints   
      
   did you find out which table has the FK before you used the 'cascade   
   constraints' option?   
      
   ++ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)