CORE-POS/IS4C

use is4c_log;

DROP VIEW IF EXISTS `cktenders`;
CREATE VIEW `cktenders` 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`.`ckTender` AS `ckTender`,
`tendertape`.`changeGiven` AS `changeGiven` 

from `tendertape` 
where (`tendertape`.`ckTender` <> 0)