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

joins

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 25, rows affected: 15, absolute service time: 0,23 sec, absolute service time: 0,23 sec 
edit mode |  history  | discussion
   locationid regionalgroup
1 122 banglore
2 123 delhi
3 124 noida
4 125 meerut
5 126 gzb
   deptid name locationid
1 10 tarun 122
2 20 harsh 123
3 30 popu 124
4 40 shubham 127
5 50 nitesh 128
   name jobid post
1 tarun 666 clerk
2 harsh 667 hr
3 popu 668 analyst
4 shubham 669 senior manager
5 nitesh 670 associate analyst
   locationid regionalgroup deptid name locationid
1 122 banglore 10 tarun 122
2 123 delhi 20 harsh 123
3 124 noida 30 popu 124
4 125 meerut NULL NULL NULL
5 126 gzb NULL NULL NULL
   locationid regionalgroup deptid name locationid
1 122 banglore 10 tarun 122
2 123 delhi 20 harsh 123
3 124 noida 30 popu 124
4 NULL NULL 40 shubham 127
5 NULL NULL 50 nitesh 128