Left join is used to retrieve the non-matching value from the left table

What is the difference of a LEFT JOIN and an INNER JOIN
statement? What is a Cartesian product? What causes it?

Question Posted / janardan baghla

1 Answers
4753 Views
Syntax Softtech, I also Faced
E-Mail Answers

Left join is used to retrieve the non-matching value from
the left table specified at left in query.And inner join or
equi join is used to retrieve the matching rows
only.Cartesian product is used to retrieve the value as
multiplication of the rows from number of tables specified
in query

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Hi this is the coding for adding data in to an xml table i want the coding for update and delete Try Dim emp_xml_doc As New XmlDocument If System.IO.File.Exists(Server.MapPath("emp.xml")) Then emp_xml_doc.Load(Server.MapPath("emp.xml")) Dim myrow_element As XmlElement myrow_element = emp_xml_doc.CreateElement("EmpDetails") Dim str As String str = "" & TxtEmpId.Text & "" & _ "" & TxtName.Text & "" & _ "" & TxtSalary.Text & "" myrow_element.InnerXml = str emp_xml_doc.DocumentElement.AppendChild(myrow_element) emp_xml_doc.Save(Server.MapPath("emp.xml")) Response.Write("Record Saved") Dim ds As New DataSet ds.ReadXml(Server.MapPath("emp.xml")) GridView1.DataSource = ds GridView1.DataBind() Else Response.Write("File does not exist.") End If Catch ex As Exception Response.Write(ex.ToString) End Try *********************** this is the xml file 100 xxx 2000 yyy dddd 77777 rrrr rrrr 6666 qaqa sini 50000 errrrrrrrr rrrrrrrrr 677777 rrr rrr 33

2128

What are type/key pairs in client script registration?

1071

What are sessions used for?

1001

How do you declare static variable? What is its lifetime?

962

What are the events in a page life cycle?

951

Is asp net front end or backend?

1003

Can you use c# without .net?

982

What is the difference between custom web user control and a custom web server control?

967

What is postback request?

986

Explain login control and form authentication.

1020

How can we apply themes to an asp.net application?

1037

What is the sequence in which ASP.NET events are processed?

1101

What parameters can you pass in the url of the api? Can get and post use the same url?

994

Explain how can we inherit a static member?

985

Can we create a multiple user simultaneously ?

1133