This content has been marked as final. Show 3 replies
Try something as in
Use not exists or not in instead of join.
If helps mark
1.) Answers references RPD objects and NOT database objects. (ref. "select distinct student_id from DatabaseName.B"
- Create analysis (1) which retrieves all student_id's from your table B
- Create analysis (2) which retrieves student_id's from table A
- Create a filter criteria on column student_id: column "student_id" -> Operator "is based on results of another analysis" -> Saved analysis = "/whereeveryoustoredthat/analysis (1)" -> Relationship "is not equal to any" -> Use values in Column "student_id"
3.) Bob's your uncle
Either use a union > Minus option
or use filter using "Filter based on results of another request" option in filters