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 |
Loading
Table1
| ID |
| 1 |
| 1 |
| 1 |
Table2
| ID |
| 1 |
| 1 |
| 1 |
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
ali tuncerPosted Mar 30, 2016, 10:10 PM
anjali khanPosted Mar 30, 2016, 8:47 AM
Krishna Rajput SinghPosted Mar 30, 2016, 6:08 AM
Chandu KumawatPosted Mar 30, 2016, 5:10 AM
Chandu KumawatPosted Mar 30, 2016, 5:09 AM
SQL INNER JOIN Syntax
FROM table1
INNER JOIN table2
ON table1.column_name=table2.column_name;
Example
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID=Orders.CustomerID
ORDER BY Customers.CustomerName;