What is Inner Joints and Outer Joints ? What is right outer joints,left outer j

What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,

Question Posted / basawaraj b

2 Answers
8006 Views
HP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner j..

Answer / sunil kumar

Inner join=>Inner join returns rows when there is at least
one match in both tables.

Outer Join=> Outer Join returns the set of all matching
records from both tables. Outer join doesn`t require each
record to be matched in both the tables.

Right Outer Join=>Return all the rows of second table ,plus
matching record of both tables.

Left Outer Join=>Return all the rows of first table,plus
matching record of both tables.

Is This Answer Correct ?

26 Yes

0 No

What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner j..

Answer / muthuk

Outer Join=> Outer Join returns the set of all matching
records from both tables. Outer join doesn`t require each
record to be matched in both the tables.

Inner join=>Inner join returns rows when there is at least
one match in both tables.

Left Outer Join=>Return all the rows of first table,plus
matching record of both tables.

Right Outer Join=>Return all the rows of second table ,plus
matching record of both tables.

Is This Answer Correct ?

5 Yes

1 No

Post New Answer

More MySQL Interview Questions

Why use mysql procedures?

0 Answers

Do while loop in mysql procedure?

0 Answers

what is JOIN? Give example & types of join?

14 Answers iMedia, Millennium, RAM Software, Satyam,

How to install mysql?

0 Answers

How can we know the number of days between two given dates using MySQL?

2 Answers Base2 Infotech, Webworks,

How do I flush privileges in mysql?

0 Answers

What do you need to connect php to mysql?

0 Answers

If we use sum function in mysql, does it return sum of that row or for that column?

0 Answers

Can a table have multiple primary keys?

0 Answers

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

0 Answers

What is mysql port?

0 Answers

How to use in conditions?

0 Answers

For more MySQL Interview Questions Click Here