Joins - Inner, Left, Right and Cross | Union | Mysql| SQL in Tamil | Logic First Tamil

[@kausigayokeshk3160]

00:17 Foreign key in SQL 02:57 Joins in MySQL explained 03:44 Understanding joins in MySQL 10:27 Explaining Joins in MySQL 14:06 Joins in SQL 14:13 Joins in MySQL 14:27 Condition for joining with EQUAL TO operator 15:55 Explaining Foreign and Union in SQL

[@rukesh.m9799]

JOINS SHORT NOTES (It veryusefull for beginners) 1. LEFT JOIN = All rows from left and matching from right. 2.RIGHT JOIN = All rows from right and matching from left. 3.INNER JOIN = Only matching rows. 4.FULL JOIN = All rows from both matching and not matching.

[@kanishkaakarthigayan8376]

Here which is left table & which is right table?

[@Success56726]

​​​@@kanishkaakarthigayan8376Left table is first table which u created right table is second table which u created

[@danushshanmugam8146]

@@kanishkaakarthigayan8376 the query is used FROM (left table) and used the JOIN (right table) , Mostly the table which has foreign key is always (left table)

[@moulee6284]

Hi madam I have cleared interview and got offer by learning from your videos great keep it up!

[@rukesh.m9799]

hello mam iam recently watching your sql playlist ,its very usefull for me. Your teaching is short and sweet explanation.thank you so much fro your free to eduacte for ALL. KEEP DOING MAM.GOD BLESS YOU AND YOUR FAMILY🙂

[@sutharshansrikumar3001]

i'm very happy to watch this videos, teaching style clear voice quality video all are great that you so much

[@AkashRaj-r1p]

Your teaching skills is awesome so easier to understand for all topics

[@aravindkmurugan1743]

i came to only for knowing joins but thinking of going thru entire sql . You explained well .Please keep doing.

[@divyaarul8995]

Hi I am from Non It background , your video is extremely helpful and easy to understand.I am planning to study all basics of Mysql from your videos Thanks for sharing your videos.

[@Shif1212]

Today is my examination day of dbms...thank you so much...finally I got a clear explanation b4 my examination

[@vanniyarajam3768]

Neenga teach pannathu superaa purinthathu mam , thankyou

[@asif1673]

Seriously wonderfull explanation Mam. many thanks to you...

[@ragavendranrajendran1087]

Super akka nalla puriuthu , Stored procedure pls teach pannunga.

[@pushpalatha3396]

Your videos are really very useful. Thanks for sharing your knowledge with us 🙂

[@jayasurya5041]

Clear voice 🙌

[@DharmalingamValaguruitinfo]

hey sister, thank you so much for this video, absolutely great to understand the joins. Right time I got this at place. I'm happy to give this feedback. Keep it up your good work ! thanks again.

[@swathiamu5834]

very helpful,clear voice and explanation mam.. thank you

[@vigneshwaran6220]

Your teaching is worth it continue your teaching

[@deepikatamilarasan]

Seriously from one video I have learnt a lot...Clear explanation...👍😍

[@aaradhanah5059]

Thank you so much! I'm studying in RMIT Melbourne I clearly understood the concept only after watching your video in tamil keep the good work

[@prabakaranragu6676]

Thank u mam, Very good explanation in ur all videos... Thank u

[@SivatheMaster]

Akka unga tutorials lam Vera Level

[@vlog.444]

Hi mam I'm asking to select as Infosys still learning this video very useful

[@RajkamalKamal-em5df]

Way of teaching ❤❤

[@shivaopyt]

Thanks madam Love from Jaffna 🥰

[@vishnu_murugan]

Even without going to college classes, now i can learn easily and instantly. Becoz of "Logic First Tamil". Such a clear and superb teaching 💯😍❤

[@LogicFirstTamil]

pls share with ur friends Vishnu

[@hikutti]

Mam, first time, I've seen an awesome video, grateful to you

[@lokeshn9833]

Initially i was hesitated to click watch, but it's worth watching.

[@maruthasankar]

🙏🙏🙏🙏🙏🙏🙏🙏🙏 nalla irunga deivame .. nantri....

[@vijaynarayanan2836]

Great effort. Please keep it up. You are helping many beginners.

[@revathigopal4231]

Thanks Sister, Very clear explanation

[@vishnupriya5044]

Thanks for sharing us 🙏 god bless you 🙏

[@Growthstory_Shivatalks]

Clear explanation.... Thanks

[@sugumarsivanesan5554]

Thanks a ton!. You are a superstar

[@balaroxx2700]

🎉super explanation sql.for data analysis nu oru playlist create pannunga mam

[@aravindr4581]

Thank you so much for such a use full video, mam.

[@vishal5756]

Great video sister ✔️

[@ramkumark1805]

Well explained mam...Thank you so much👏🔥

[@prasathbala7789]

Crystal clear akka

[@varunshankar9749]

very helpfull for me ....means a lot

[@rajeshrajendiran3403]

Very useful for beginners

[@kousikraj4597]

Nice explanation👌

[@LolLol-g1f8b]

8:57 perfect

[@carthicksiva]

Thanks !! for Explanation!

[@Devasinger-0070]

which is faster between using join keyword or where clause condition

[@funwithyg5913]

Very well explained

[@miacreations247]

List down the employees who's reporting to them including president idha eppadi query pandradhu madam

[@j.k.satheeshkumar1695]

Clear explanation 👌

[@nagarajans3467]

Thank you for your class maam

[@arunraju4878]

Hi mam.. nice explanation please try to upload videos related to normalization

[@vignaharisgk4523]

Informative

[@LolLol-g1f8b]

9.05 good explanation 🎉

[@LolLol-g1f8b]

9:12 good one kaa🎉

[@ln2752]

thanks for your video.

[@kathiravank8063]

Thank you Sis..

[@ShivaKumar-qb2hc]

How to contact you mam .. present i am preparing informatica powercenter...i have some doubts to ask you madam

[@Dmahaprabhu-x3z]

MAM WE CAN USE LEFT JOIN QUERY UNION RIGHT JOIN QUERY FOR FULL JOIN IN MYSQL.

[@suriyars5662]

Hi mam ... I also got placed in Zensar Technologies mam by studying basics of c and java from your videos 🤗 Thank You mam When can we expect sequences topics from SQL ?

[@LogicFirstTamil]

Congrats! I am planning to cover just three more lessons in sql and windup. I have plans for other topics. Will try to add more in future.

[@suriyars5662]

Then can u please tell us about TCL commands (or) about single row function and it's 5 types (or) Flashback,Purge something like this can u please explain in your video mam it will be very much use full even if u cover all those topics mam ✨

[@ashuzakir5474]

Mam please make a video of outerjoin, Self join and Equivjoin

[@ANISHADEVARAJ-v7h]

perfect ✅

[@mohamednasik7959]

I have a doubt in the when then statement.

[@ln2752]

subscribed 👍

[@sathishsmartworker1668]

Hi mam... Enaku join la oru question ketanga athuku epadi answer varumnu konjam sollunga mam 2 tables are there 1 is A table 2nd is B table. In A table column name is C1 values are 1 1 1 null total 4 rows . B table has column name is C2 values are 1 1 1 null. Question is how many records will come in inner join, left join, right join, full outer join and cross join. Please reply with answer mam. Thank you!

[@PaulSelvi-cl4gr]

Superb mam

[@RajeshKumar-th8pz]

In joining can we use * to get all data

[@msyt6286]

Yesh

[@surya.r3463]

thank you mam...

[@sindhusharmi7156]

Really usefull

[@sujithaa2793]

I got placed mam thankyou

[@akaskar]

Thank you

[@sribhavani2486]

Mam what is self join??😢

[@abdulrahmanraziq809]

mam where can i get the data mam for me to practice

[@vsarala7322]

Get data from kaggle

[@thageetanvi1226]

Thanks

[@lovelyagi4717]

MAM PLEASE POST VODEO ABOUT ER DIAGRAM AND RELATIONAL ALGEBRA QUERIES .....PLS PLS I REFER MORE VIDEO I CANNOT UNDER STAND PLS MAKE VIDEO AND POST

[@hey_itz_me_divya]

Text konjam perusa kattumga pls

[@uCSSAVARIIRUTHAYARAJ]

Akkka left Anti join right anti join ah pathi oru video potunga ka plzzz 😑😓😬😬🥺🥺

[@abishektamilan9733]

Akka data science soli kundunga

[@Smith-zz5dq]

supper

[@bharathkumar4502]

Inner join purila

[@vishanthvenkat6103]

U missed UNION ALL

[@suryaprakashsakthivel8277]

♥️🙏

[@veerasakthivela1966]

💙

[@இயற்கைஓர்தன்னலமற்றது]

Super Akka nice...

[@Balajiji4888]

Thank you Mam

[@sabitha3435]

Thank you mam