test Join query :

Test /gcc/handwritten/java/test/QueryRuleUtilTest.java

• create db xqtlworkbench & run XqtlWorkbenchUpdateDatabase?.java
• create db xqtleuratrans

Run As application "JoinQueryExample?" , works for Use UseCase? that has data . Individual insert data fails :

ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`xqtleuratrans`.`individual`, CONSTRAINT `individual_ibfk_1` FOREIGN KEY (`id`) REFERENCES `observationtarget` (`id`) ON DELETE CASCADE)

• Upper case issue in mysql. or Individual id is a foreign key to another table : 
  • Fix that . 

Lifelines presentation and data

Got presentation