documentation/Reference Code/Wedge/installation/mysql/is4c_log/views/cctenders.viw
use is4c_log;
DROP VIEW IF EXISTS `cctenders`;
CREATE VIEW `cctenders` AS
select
`tendertape`.`tdate` AS `tdate`,
`tendertape`.`emp_no` AS `emp_no`,
`tendertape`.`register_no` AS `register_no`,
`tendertape`.`trans_no` AS `trans_no`,
`tendertape`.`ccTender` AS `ccTender`,
`tendertape`.`changeGiven` AS `changeGiven`
from `tendertape`
where (`tendertape`.`ccTender` <> 0)