statement. Consider the following query: ( ) To find various amounts of sales during the month of April, and the amounts of such sales if the prices of products are allowed to be raised by %. ( Model-I ) Vdate, Credit, Amount, Amount* . AS Expected Vouchers, Accounts Credit = Code AND name LIKE “Sales Account*” ( Model-II ) Vdate, D.code, Amount, Amount* .
AS Expected Vouchers AS V, Details AS D, accounts AS A V.vNo = D.vNo AND D.code = A.Code AND A.Name LIKE “Sales Account*” AND tType = UNION Vdate, V. , Amount, Amount* . AS Expected Vouchers AS V, Details AS D, accounts AS A V.vno = D.vno AND V. = A.code AND A.name LIKE “Sales Account*” AND Ttype = ;