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

google api - Incomplete response from Gmail API threads.list -

Installing Android SQLite Asset Helper -

Qt Creator - Searching files with Locator including folder -