Add a column with default value while creating the new table
Posted on 2012-09-02
I am using the following query statement. I need to add an additional flag column to the new table "CLMU1" with a default value of "1" for each line that is created in the new table.
SELECT CLDISPENSE.COMPANY, CLDISPENSE.SSNO, CLDISPENSE.FACILITY, CLDISPENSE.INTERNAL, CLDRCRED.DOCTOR, CLDISPENSE.DISPENSEDATE, CLDISPENSE.NOTE
FROM CLDISPENSE LEFT OUTER JOIN
CLDRCRED ON CLDISPENSE.COMPANY = CLDRCRED.COMPANY AND CLDISPENSE.USERCODE = CLDRCRED.PROVID