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
Post a Comment