Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

SQL_join_examples

Language: Layout:
View schema
Execution time: 0,05 sec, rows selected: 43, rows affected: 8, absolute service time: 0,22 sec 
edit mode |  history
   sql server version
1 Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) Feb 20 2014 19:20:46 Copyright (c) Microsoft Corporation Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)
   id NAME club
1 1 Pupil 1 Club 1
2 2 Pupil 2 Club 2
3 3 Pupil 3 Club 2
4 4 Pupil 4 NULL
   id club_name club_detail
1 1 Club 1 Detail 1
2 2 Club 2 Detail 2
3 3 Club 3 Detail 3
4 4 Club 4 Detail 4
   id NAME club id club_name club_detail
1 1 Pupil 1 Club 1 1 Club 1 Detail 1
2 2 Pupil 2 Club 2 1 Club 1 Detail 1
3 3 Pupil 3 Club 2 1 Club 1 Detail 1
4 4 Pupil 4 NULL 1 Club 1 Detail 1
5 1 Pupil 1 Club 1 2 Club 2 Detail 2
6 2 Pupil 2 Club 2 2 Club 2 Detail 2
7 3 Pupil 3 Club 2 2 Club 2 Detail 2
8 4 Pupil 4 NULL 2 Club 2 Detail 2
9 1 Pupil 1 Club 1 3 Club 3 Detail 3
10 2 Pupil 2 Club 2 3 Club 3 Detail 3
11 3 Pupil 3 Club 2 3 Club 3 Detail 3
12 4 Pupil 4 NULL 3 Club 3 Detail 3
13 1 Pupil 1 Club 1 4 Club 4 Detail 4
14 2 Pupil 2 Club 2 4 Club 4 Detail 4
15 3 Pupil 3 Club 2 4 Club 4 Detail 4
16 4 Pupil 4 NULL 4 Club 4 Detail 4
   NAME club_name
1 Pupil 1 Club 1
2 Pupil 2 Club 2
3 Pupil 3 Club 2
   NAME club_name
1 Pupil 1 Club 1
2 Pupil 2 Club 2
3 Pupil 3 Club 2
4 Pupil 4 NULL
   NAME club_name
1 Pupil 1 Club 1
2 Pupil 2 Club 2
3 Pupil 3 Club 2
4 NULL Club 3
5 NULL Club 4
   NAME club_name
1 Pupil 1 Club 1
2 Pupil 2 Club 2
3 Pupil 3 Club 2
4 Pupil 4 NULL
5 NULL Club 3
6 NULL Club 4