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

[@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)

[@AkashRaj-r1p]

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

[@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🙂

[@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.

[@moulee6284]

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

[@sutharshansrikumar3001]

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

[@aravindkmurugan1743]

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

[@ragavendranrajendran1087]

Super akka nalla puriuthu , Stored procedure pls teach pannunga.

[@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

[@vanniyarajam3768]

Neenga teach pannathu superaa purinthathu mam , thankyou

[@asif1673]

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

[@hikutti]

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

[@swathiamu5834]

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

[@Shif1212]

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

[@vlog.444]

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

[@balaroxx2700]

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

[@SivatheMaster]

Akka unga tutorials lam Vera Level

[@pushpalatha3396]

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

[@vigneshwaran6220]

Your teaching is worth it continue your teaching

[@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.

[@prabakaranragu6676]

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

[@deepikatamilarasan]

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

[@revathigopal4231]

Thanks Sister, Very clear explanation

[@RajkamalKamal-em5df]

Way of teaching ❤❤

[@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

[@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

[@shivaopyt]

Thanks madam Love from Jaffna 🥰

[@vishnupriya5044]

Thanks for sharing us 🙏 god bless you 🙏

[@lokeshn9833]

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

[@sugumarsivanesan5554]

Thanks a ton!. You are a superstar

[@maruthasankar]

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

[@aravindr4581]

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

[@varunshankar9749]

very helpfull for me ....means a lot

[@Balajiji4888]

Thank you Mam

[@vijaynarayanan2836]

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

[@vishal5756]

Great video sister ✔️

[@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 ✨

[@prasathbala7789]

Crystal clear akka

[@rajeshrajendiran3403]

Very useful for beginners

[@kathiravank8063]

Thank you Sis..

[@ln2752]

thanks for your video.

[@carthicksiva]

Thanks !! for Explanation!

[@nagarajans3467]

Thank you for your class maam

[@funwithyg5913]

Very well explained

[@kousikraj4597]

Nice explanation👌

[@LolLol-g1f8b]

8:57 perfect

[@ramkumark1805]

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

[@Devasinger-0070]

which is faster between using join keyword or where clause condition

[@LolLol-g1f8b]

9.05 good explanation 🎉

[@LolLol-g1f8b]

9:12 good one kaa🎉

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

Super Akka nice...

[@arunraju4878]

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

[@j.k.satheeshkumar1695]

Clear explanation 👌

[@ShivaKumar-qb2hc]

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

[@sujithaa2793]

I got placed mam thankyou

[@miacreations247]

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

[@ashuzakir5474]

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

[@Dmahaprabhu-x3z]

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

[@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!

[@ln2752]

subscribed 👍

[@sindhusharmi7156]

Really usefull

[@thageetanvi1226]

Thanks

[@RajeshKumar-th8pz]

In joining can we use * to get all data

[@uCSSAVARIIRUTHAYARAJ]

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

[@mohamednasik7959]

I have a doubt in the when then statement.

[@sribhavani2486]

Mam what is self join??😢

[@Smith-zz5dq]

supper

[@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

[@abdulrahmanraziq809]

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

[@vsarala7322]

Get data from kaggle

[@abishektamilan9733]

Akka data science soli kundunga

[@hey_itz_me_divya]

Text konjam perusa kattumga pls

[@suryaprakashsakthivel8277]

♥️🙏

[@bharathkumar4502]

Inner join purila

[@veerasakthivela1966]

💙

[@vishanthvenkat6103]

U missed UNION ALL

[@PaulSelvi-cl4gr]

Superb mam

[@akaskar]

Thank you

[@surya.r3463]

thank you mam...