Hi there
I have 3 tables Student, Book, StudentBook
Now I want to pick up all those records which doesn't exists int the StudentBookTable(RelatedTable) . Can anyone tell me how to do that?.
i.e
select * from students where studentid not in (select studentid from studentbook)
How to do this in self service with EntityCollection