Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
join
create table emp (id int, name varchar(20), address varchar(20) ); insert into emp( id, name , address) values ( 1, 'tarun', 'meerut'), (2, 'harsh', 'delhi'), (3, 'popu', 'goa'), (4, 'nitesh', 'gzb'), (5, 'ram', 'noida'); select * from emp; create table dept( id int, dept_no varchar(20), post varchar(20)); insert into dept ( id, dept_no, post) values (1, 'd1', 'hr'), (2, 'd2', 'it'), (4, 'd3', 'analyst'), (5, 'd4', 'senior analyst'); select * from dept; select emp.id, emp.name, dept.post, dept.dept_no from emp inner join dept on emp.id=dept.id; select emp.id , emp.name, dept.id, dept.post from emp left join dept on emp.id=dept.id; select emp.id , emp.name, dept.id, dept.post from emp right join dept on emp.id=dept.id;
run
|
edit
|
history
|
help
0
StackOverflow_53799678
Sql Server sys.syslanguages
hi
bc160401693
i need help
Movies
pivot example
BC160401693
2021-03-09_LeetCodeSQL
QLSV