select I.itemid,I.itemname from Item as I,itempermission as IP where I.itemid=IP.productid
select I.itemid,I.itemname,I.companyname from Item I Inner join itempermission IP on I.itemid=IP.productid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)