Comments by zunisheikh

zunisheikh 2-Mar-14 14:24pm View

SELECT ord.orderid,cus.custid,cus.custname,cat.catid,cat.catname,pro.proid,pro.proname from `order` as ord inner join`customer` as cus on cus.custid=ord.custid inner join `category` as cat on cat.catid=ord.catid inner join `product` as pro on pro.proid=ord.proid

yes i did this bt still it select no record.what should i do

zunisheikh 2-Mar-14 13:35pm View

hey i resolved this issue by myslef :)
thanks alot dear

zunisheikh 2-Mar-14 13:27pm View

custid catid proid orderid quantity deldate totalbill orderstatus deladdress
Edit Delete
1 1 1 1 5 2014-02-04 200 avaliable g-10
its shows customer id product id and category id bt i want here name of customer ,category and product

zunisheikh 2-Mar-14 13:26pm View

no no i am a software developer
bt its my start
thats y i am stuck

zunisheikh 2-Mar-14 10:52am View

SELECT ord.orderid,cus.custid,cus.custname,cat.catid,cat.catname,pro.proid,pro.proname from 'order' as ord inner join 'customer' as cus on cus.custid=ord.custid inner join 'category' as cat on cat.catid=ord.catid inner join 'product' as pro on pro.proid=ord.proid
now itz like this

zunisheikh 2-Mar-14 10:51am View

u r write dear
i edit these mistakes bt still it didnt work
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''order' as ord inner join 'customer' as cus on cus.custid=ord.custid inner join' at line 1

Comments by zunisheikh (Top 6 by date)