CREATE VIEW viewinstallinfo AS SELECT i.installid, i.customerid, i.username, iu.internetpassword, i.installdate, i.installmiti, i.billdate, i.billmiti, i.entrydate, i.entrymiti, i.billno, pk.packagesalesid AS freepackagerateid, i.purchasepackageid, si.salesid, i.installcharge, i.total, i.other, i.discount, i.netamount, i.remarks FROM tblinstallinfo AS i JOIN tblinternetuser AS iu ON i.username = iu.internetusername JOIN tblsalesinfo AS si ON i.installid = si.installid JOIN tblpackagesales AS pk ON i.freepackageid = pk.packagerateid, i.installid = pk.installid WHERE pk.remarks = 'free'
JOIN tblpackagesales AS pk ON i.freepackageid = pk.packagerateid, i.installid = pk.installid
JOIN tblpackagesales AS pk ON i.freepackageid = pk.packagerateid and i.installid = pk.installid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)