12:07 am getting error while using the full join. “Full” is not valid at this position, expecting EOF, ‘;’ How to fix it? Am using MySQL work bench 8.0. Version 8.0.31 .community version
Hi @ManivannanGD, my tutorial videos are based on Microsoft SQL Server (MSSQL). Mysql doesn't support "Full join". Alternative is combining the results of left and right join using union. Something like this would work. select * from employee e left join department d on e.DepartmentID =d.DepartmentID union select * from employee e right join department d on e.DepartmentID =d.DepartmentID Hope this helps.
Hi, When you join two tables like this "tableA join tableB", the first table "tableA" is called the left table and the second table "tableB" is called the right table.
Hi @karthikeyans2360 yes, when you join two tables, you can select any columns from both the tables. If both the tables have same column name, use . or . to differentiate.
Hi @akash0150, yes you can use the conditions in the where clause without specifying any implicit joins and just separate the table names using commas. But the preferred one will be using explicit joins and "on" clause conditions as it helps in readability and clarity. "Where" clause can also have other filtering conditions in addition to the join conditions. So its better to separate them out.
Very very easy Video of Joins 🎉👏👏👏very much cleared mam😊thank u so much
Thanks @abineshanitha9223
Thank you so much mam.. clear explanation ❤
Awesome 🎉 and Nice explanation Mam
Very very good your way of teaching is very easy to understand topic.thank you
thank you so much mam
Romba nalla purithu mam, na ippo BCA final year IDE la pandra book la padicha kuda ippadi puriyathu tq mam
Wow very clear explanation Thank you so much Mam.
Thanks @cehpurushothaman6165
Your voice is very clear ❤
Awesome teaching methods❤
Thanks @nsprakash6539
Super ra sonninga mam
Hi sis..nice explanation can you help in importing a dataset to the sql server..getting a lot of errors
Clear explanation mam
Thanks @renugarenu4720
Super sister
12:07 am getting error while using the full join. “Full” is not valid at this position, expecting EOF, ‘;’
How to fix it?
Am using MySQL work bench 8.0. Version 8.0.31 .community version
Hi @ManivannanGD, my tutorial videos are based on Microsoft SQL Server (MSSQL). Mysql doesn't support "Full join". Alternative is combining the results of left and right join using union. Something like this would work.
select * from employee e
left join department d
on e.DepartmentID =d.DepartmentID
union
select * from employee e
right join department d
on e.DepartmentID =d.DepartmentID
Hope this helps.
Mass🎉🎉
Thanks @suriyakarnan5006
super mam,i want to know about self join
mam ur videos are very useful.thank you . can you pls tell me what is the left table /right table
Hi, When you join two tables like this "tableA join tableB", the first table "tableA" is called the left table and the second table "tableB" is called the right table.
nice
Can you explain self join with same example
mam please upload MSSQL full course for beginners
Sure @magarajothik3144
6:58 rendu table la irrundhu column select panna mudiyuma mam
Hi @karthikeyans2360 yes, when you join two tables, you can select any columns from both the tables. If both the tables have same column name, use . or . to differentiate.
@@TechWithHema okay I found that and learnt too
Mam instead of on where use panalama ? Illa on than use pannanuma
Hi @akash0150, yes you can use the conditions in the where clause without specifying any implicit joins and just separate the table names using commas. But the preferred one will be using explicit joins and "on" clause conditions as it helps in readability and clarity. "Where" clause can also have other filtering conditions in addition to the join conditions. So its better to separate them out.
@@TechWithHema Maam, tamil'la doubt kekravanga kitta tamil'laye reply pannunga maam please. 🙏