how to use join query to merge order,customer,category and product table?
-
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 kindly reply where i am wrong:(
-
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 kindly reply where i am wrong:(
Don't repost questions. Don't bump questions frequently, that's annoying. Wait for the answers.
thatraja
Code converters | Education Needed No thanks, I am all stocked up. - Luc Pattyn When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
-
Don't repost questions. Don't bump questions frequently, that's annoying. Wait for the answers.
thatraja
Code converters | Education Needed No thanks, I am all stocked up. - Luc Pattyn When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
ok actually its my first time to use sch type of site.Its really a good site.Nd actually I was in trouble thats why i asked question.But Sorry if you fell annoyed .Next time I will avoid it.
-
ok actually its my first time to use sch type of site.Its really a good site.Nd actually I was in trouble thats why i asked question.But Sorry if you fell annoyed .Next time I will avoid it.
zunisheikh wrote:
ok actually its my first time to use sch type of site.
But your profile page says 1 year old member. Anyway hereafter avoid reposts. I think we have answered all of your questions.
thatraja
Code converters | Education Needed No thanks, I am all stocked up. - Luc Pattyn When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute