Joined: 12 Jul 2010 Posts: 1 Location: pune - india
I need to write a olq query. where i need to find out the totalcount of the records which do not have relation to the child.
for ex:- If there are 4 records A,B.C and D. where A is linked with B as
A-B, A is linked with C as A-C and A is linked with D as A-D. where B,C and D are child record of the A. I need to write a query where it counts the number of records available in A where it is not related with any of the child records B or C or D.
If anyone can share the query to achieve this please respond.