Hello All,
I tried executing the following SQL code in NetBeans IDE: CREATE ASSERTION PartialRetiringEquipment CHECK ( (SELECT COUNT (R.PTTEquipmentID) FROM RetiredEquipment R) < = (SELECT COUNT (All.PTTEquipmentID) FROM Equipment All) ) I received the following error message: An error has occurred during execution: Syntax error: Encountered "ASSERTION" at line 1, column 8 I am using Derby 10.2.1.6 on Windows XP Professional. I appreciate any help. Thanks, Sisilla
