SELECT table1.*,table2.* From table1 inner join table2 on table1.Column = table2.column where table1.column = '1'
SELECT it.itemId, it.catid, it.itemName, ct.Category_name, it.Price FROM ItemTable it JOIN CetegoryTable ct ON it.Catid=ct.catid
SELECT C.Catid, C.category_name, I.itemid, I.itemname, I.details, I.price FROM Category C INNER JOIN Item I ON C.Catid == I.Catid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)