Select rows with same ID/email but different value in other table, Sql Server

Select rows with same ID/email but different value in other table

Language: Layout:

View schema
Execution time: 0,03 sec, rows selected: 8, rows affected: 6, absolute service time: 0,19 sec

edit mode | history

  
person_id
email
rn

1
1
email@persoon1
1

2
4
email@persoon1
2

3
2
email@persoon2
1

4
6
email@persoon2
2


  
person_id
email

1
1
email@persoon1

2
2
email@persoon2

3
4
email@persoon1

4
6
email@persoon2

λ

                                      .NET NoSQL database for rapid development