master
use is4c_op; DROP VIEW IF EXISTS `chargecodeview`; create view chargecodeview as select c.staffID, c.chargecode, d.blueLine from chargecode c, custdata d where c.staffID = d.CardNo