Cross and outer apply, Sql Server

Cross and outer apply

Language: Layout:

View schema
Execution time: 0 sec, rows selected: 20, rows affected: 0, absolute service time: 0.3 sec

edit mode | history | discussion

  
ID
First_name
Last_name
Title
Birth_date
Pilots_ID

1
1
John
Smith
First pilot
5/5/1965 12:00:00 AM
NULL

2
2
John
Doe
Second pilot
1/2/1970 12:00:00 AM
1

3
3
William
Lee
Third pilot
3/27/1975 12:00:00 AM
2

4
4
Steve
Quick
Fourth pilot
12/23/1980 12:00:00 AM
3


  
ID
First_name
Last_name
Title
Birth_date
Pilots_ID
func_ID

1
1
John
Smith
First pilot
5/5/1965 12:00:00 AM
NULL
1

2
2
John
Doe
Second pilot
1/2/1970 12:00:00 AM
1
1

3
3
William
Lee
Third pilot
3/27/1975 12:00:00 AM
2
1

4
4
Steve
Quick
Fourth pilot
12/23/1980 12:00:00 AM
3
1

5
1
John
Smith
First pilot
5/5/1965 12:00:00 AM
NULL
5

6
2
John
Doe
Second pilot
1/2/1970 12:00:00 AM
1
5

7
3
William
Lee
Third pilot
3/27/1975 12:00:00 AM
2
5

8
4
Steve
Quick
Fourth pilot
12/23/1980 12:00:00 AM
3
5


  
ID
First_name
Last_name
Title
Birth_date
Pilots_ID
func_ID

1
1
John
Smith
First pilot
5/5/1965 12:00:00 AM
NULL
1

2
1
John
Smith
First pilot
5/5/1965 12:00:00 AM
NULL
5

3
2
John
Doe
Second pilot
1/2/1970 12:00:00 AM
1
1

4
2
John
Doe
Second pilot
1/2/1970 12:00:00 AM
1
5

5
3
William
Lee
Third pilot
3/27/1975 12:00:00 AM
2
1

6
3
William
Lee
Third pilot
3/27/1975 12:00:00 AM
2
5

7
4
Steve
Quick
Fourth pilot
12/23/1980 12:00:00 AM
3
1

8
4
Steve
Quick
Fourth pilot
12/23/1980 12:00:00 AM
3
5

λ

                                      .NET NoSQL database for rapid development