sql - Inner join with mysql not works -


hey guys new mysql development , trying inner join both tables ..my code

select customers.name, oop.id customers(select name,id orders) oop inner join oop on customers.name=oop.id order customers.name; 

when tried code shows me error know can done other method have seen method on website tried..am doing error in code.

hope guys can me out ..any appreciated ..thanx

you writing wrong syntax. somthing this:-

select customers.name, oop.id customers inner join (select name,id orders) oop on customers.name=oop.id order customers.name; 

Comments

Popular posts from this blog

qml - Is it possible to implement SystemTrayIcon functionality in Qt Quick application -

double exclamation marks in haskell -

javascript - How to get D3 Tree link text to transition smoothly? -