Joins in SQL | Sql in Tamil | Tech with Hema Tamil

Joins in SQL | Sql in Tamil | Tech with Hema Tamil
#sql #sqlintamil
Learn Joins in tamil. You will see more videos in sql basics that will be coming soon. Please add your comments in the comment box if you like me to cover any other topics in sql that you are interested. Thank you.
Queries used in the video can be accessed in drive.google.c...
Installation of Microsoft SQL server and SQL server management studio - • Installation of Micros...
Import AdventureWorks database - learn.microsof...

[@abineshanitha9223]

Very very easy Video of Joins 🎉👏👏👏very much cleared mam😊thank u so much

[@TechWithHema]

Thanks @abineshanitha9223

[@jenilkiruba6896]

Very very good your way of teaching is very easy to understand topic.thank you

[@ajshagibgm7011]

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

[@thesayoung6148]

Awesome 🎉 and Nice explanation Mam

[@cehpurushothaman6165]

Wow very clear explanation Thank you so much Mam.

[@TechWithHema]

Thanks @cehpurushothaman6165

[@NaTurE_.loVe.__.it._]

Your voice is very clear ❤

[@nsprakash6539]

Awesome teaching methods❤

[@TechWithHema]

Thanks @nsprakash6539

[@rashmikajothi]

Hi sis..nice explanation can you help in importing a dataset to the sql server..getting a lot of errors

[@renugarenu4720]

Clear explanation mam

[@TechWithHema]

Thanks @renugarenu4720

[@vekaashini]

super mam,i want to know about self join

[@Jai-dk1kp]

Super sister

[@magarajothik3144]

mam please upload MSSQL full course for beginners

[@TechWithHema]

Sure @magarajothik3144

[@chiller47]

nice

[@ManivannanGD]

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

[@TechWithHema]

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.

[@suriyakarnan5006]

Mass🎉🎉

[@TechWithHema]

Thanks @suriyakarnan5006

[@akash0150]

Mam instead of on where use panalama ? Illa on than use pannanuma

[@TechWithHema]

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.

[@RajeswaranKuppusamy]

@@TechWithHema Maam, tamil'la doubt kekravanga kitta tamil'laye reply pannunga maam please. 🙏

[@karthikeyanskk9762]

6:58 rendu table la irrundhu column select panna mudiyuma mam

[@TechWithHema]

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.

[@karthikeyanskk9762]

@@TechWithHema okay I found that and learnt too