write a query for inner join below table with output??

Question

hi frnds I have a 2 tables....write a query for inner join with output??? Table1 ID 1 1 1 Table2 ID 1 1 1

ali tuncer · Answer

it would be 9 rows of 1..

anjali khan · Answer

ok...that is i know....but i dont hv sql so wants to output.. what is the output for the above tabel??

Krishna Rajput Singh · Answer

Hello anjali khan thanks fr writing below links i hope helpful for you..:) http://www.sqlbook.com/SQL/INNER-JOIN-37.aspx http://www.tutorialspoint.com/sql/sql-inner-joins.htm http://stackoverflow.com/questions/23558497/how-to-write-a-sql-query-to-inner-join-2-tables-without-duplicate-data Special thanks c-sharpcorner.com

Chandu Kumawat · Answer

SELECT * FROM table1 INNER JOIN table2 ON table1 . primaryKey = table2 . table1Id INNER JOIN table3 ON table1 . primaryKey = table3 . table1Id

Chandu Kumawat · Answer

SQL INNER JOIN Syntax SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name ; Example SELECT Customers.CustomerName Orders.OrderID FROM Customers INNER JOIN Orders ON Customers.CustomerID=Orders.CustomerID ORDER BY Customers.CustomerName;