SQL Join Multiple table query

Question

I wrote following code:

 cmd = new SqlCommand("Select City.City, Company.Company,Emp_Depart.Department,Emp_Name.Uname from Emp_Name INNER join Emp_Name on" +
            "Emp_Name.Id=Emp_Depart.Id Emp_Name.Id=Company.Id Emp_Name.Id=City.Id where Emp_Name.Id=" + txtId.Text);
 cmd.Connection = con;
 da = new SqlDataAdapter(cmd);
 dt = new DataTable();
 da.Fill(dt);
 txtName .Text = dt.Rows[0][1].ToString().Trim();

I am getting following error

Additional information: Incorrect syntax near '.'.

I am newbie for Joins Please help me out...

Please correct your query. After Inner join, you should use equal to operator between only two columns or you should use And/OR operator in between. You have multiple column comparision after ON. — Paresh J
– Paresh J, Commented Nov 17, 2014 at 6:08

Pரதீப் · Accepted Answer · 2014-11-17 06:38:45Z

2

You missed And operator in join condition

SELECT CITY.CITY,
       COMPANY.COMPANY,
       EMP_DEPART.DEPARTMENT,
       EMP_NAME.UNAME
FROM   EMP_NAME
       INNER JOIN EMP_DEPART
               ON EMP_NAME.ID = EMP_DEPART.ID
       INNER JOIN COMPANY
         ON EMP_NAME.ID = COMPANY.ID
       INNER JOIN CITY
         ON EMP_NAME.ID = CITY.ID 
WHERE EMP_NAME.ID =+ TXTID.TEXT

edited Nov 17, 2014 at 6:38

answered Nov 17, 2014 at 6:08

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

surya Over a year ago

Thanks Pradeep, But I am getting another error Additional information: Incorrect syntax near the keyword 'INNER'.

surya Over a year ago

I used same code what you posted and tried to execute but it is showing error " Incorrect syntax near the keyword 'INNER'".

Pரதீப் Over a year ago

@surya You were missing some tables in join. updated check now.

surya Over a year ago

Thank you so much worked for me now learned new thing from you

danish · Accepted Answer · 2014-11-17 06:09:20Z

0

You need to add AND between multiple join conditions. Also, add a space after EMP_name on.

answered Nov 17, 2014 at 6:09

danish

5,6002 gold badges27 silver badges28 bronze badges

Collectives™ on Stack Overflow

SQL Join Multiple table query

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related