SQL Joins - inner join, left join, right join, full outer join, cross join

-

 drop table if exists table1;

create table table1(id VARCHAR(30));


insert into table1 (id) values (1), (2), (3), (4), (5), (null)

--insert into table1 values ('hello')

--error in joins if in on condition we use this table with other interger value table

-- not error if we use only table 2 interger value with integer. table.id = 2; 

--like tihs select * from table2 left join table1 on table2.id = 2;


select * from table1;


drop table if exists table2;

create table table2 (id integer);


insert into table2 (id) values (2), (2), (6), (4);

--insert into table2 (id) values ("hello");


select * from table2;


select * from table1;

select * from table2;

--inner join


select * from table1 inner join table2 on table1.id = table2.id;


select * from table1,table2 where table1.id = table2.id;


select * from table1 cross join table2 where table1.id = table2.id;

-- error if we use "on" in crossjoin. use where clause with crossjoin.

--iner join on = cross join where = same result


select * from table1 cross join table2; --rows 6*4 = 24. 


select * from table1 cross join table2 where table2.id =2 ; --rows 7*4 = 28 (varchar , interger. in varchar add 'hello' string row.) 

--no error but if we use where condition like table2.id = table1.id then there will be an error.


-- right join with out 'hello' add


select * from table1 right join table2 on table1.id = table2.id;


--left join without add 'hello'

select * from table1 left join table2 on table1.id = table2.id;

--7th row will be NULL NULL. in sql NULL <> NULL.


--FULL OUTER JOIN. UNIOUN OF LEFT AND RIGHT JOIN. 

SELECT * FROM table1 full outer join table2 on table1.id = table2.id;

Comments

Post a Comment

Popular Posts

15 Cases where True Indology exposed Devdutt Pattanaik

-
Image
I am one out of such thousands of Twitter users who finds True Indology ( @tiinexile ) to be the best available source of knowledge regarding India’s History. I decided to compile those 15 cases where True Indology has exposed fraud claims of Devdutt Pattanaik on Twitter. Case 1 Devdutt Pattanaik’s Claim :    True Indology’s Response:  "A woman is pure. Nothing about her is impure. Without her, no man would exist"- Kokashastra "Where women are revered, there the Gods rejoice"- Manusmriti Hinduism is the only extant religion that worships feminine as divine. I challenge you to produce a source for the statement Case 2 Devdutt Pattanaik's : Article - A classical language by devdutt pattanaik. Below screenshot is from that article True Indology’s Response:  In this article, Devdutt Pattanaik says that Prakrit came earlier than Sanskrit. I would have laughed at his ignorance, his utter lack of basic linguistic knowledge, and
Read more

Maharishi Sushruta : Father of Indian Medicine, Father of Plastic Surgery- A Great Rishi and Scholar

-
Image
Maharishi Shushruta ( Sanskrit: सुश्रुत ) is a legendry scholar of the Indian medical science and founding father of surgery. 2600 Yrs ago Maharishi Shushruta together with his colleagues had conducted a variety of complex surgeries such as caesareans, artificial limbs, cataract, urinary stones, fractures, and most specially the plastic surgery. Ayurveda has its foundation in a triology of books. one of which is sushruta samhita. other two are charak samhita and astanga hridaya. Historian believe that he lived in 6th - 7th century BC and Practiced his work on the banks of river ganga in modern day varanasi. A famous book (Shalya Tantra) has been described by the Shushruta about all the surgical procedures. Shalya Tantra was later named as the Sushruta Samhita (have details about the ancient medical science of India, well known as the Ayurveda). Maharishi Shushruta is the author of Sushruta Samhita in Sanskrit language and had described all the amazing surgical procedures with accuracy
Read more

Mythologist Author Devdutt Pattanaik's Abusive Tweets

-
Image
Who is Devdutt Pattanaik ?  Devdutt Pattanaik  is an Indian mythologist, [1]  speaker, illustrator, and author, [2]  known for his writing on sacred lore, legends, folklore, fables, and parables. [3]  His work focuses largely on the areas of myth, religion, mythology, and management. Pattanaik has incorporated the Mahabharata and the Ramayana into human resource management. [4]  He has written books on the relevance of sacred stories, symbols, and rituals in modern times; his more popular books include  Myth = Mithya: A Handbook of Hindu Mythology [5] ;   Jaya: An Illustrated Retelling of the Mahabharata [6] ;  and  Sita: An Illustrated Retelling of the Ramayana [7]  and My Gita. Pattanaik writes columns for  Mid-Day , [8]  Times of India, [9]   Swarajya , [10]  CN Traveller, [11]  Daily O [12]  and Scroll.in. [13]  He hosts a radio show/podcast for Radio Mirchi  [14]  called the Devdutt Patnaik Show. - Wikipedia In a world without social media, Pattanaik would most likely continue to
Read more