Pls help me to close the error,reg Materuialized query table.

db2 => create SUMMARY table mqt as (select cs.model,cs.vemail,cs.made
cs_made,cs.updat,c
s.subscrib,cs.spcl1,cs.spcl2,cs.spcl3,cs.spcl4,cs.spcl5,cs.spcl6,cs.spcl7,cs.spc
l8,ct.to_page, ct.made ct_made,ct.campaign from cust_spec cs, click_thru
ct w
here (cs.vemail=ct.vemail)) DATA INITIALLY DEFERRED REFRESH IMMEDIATE

Other command

db2 => create SUMMARY table mqt as (select cs.model,cs.vemail,cs.made
cs_made,cs.updat,c
s.subscrib,cs.spcl1,cs.spcl2,cs.spcl3,cs.spcl4,cs.spcl5,cs.spcl6,cs.spcl7,cs.spc
l8,ct.to_page, ct.made ct_made,ct.campaign from cust_spec cs, click_thru
ct w
here (cs.vemail=ct.vemail)) DATA INITIALLY DEFERRED REFRESH IMMEDIATE

Result :
DB21034E The command was processed as an SQL statement because it was not
a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token ")" was found following
"cs.vemail=ct.vemail)".
Expected tokens may include: "<table_expr>". SQLSTATE=42601


regards
saiprasad

DB2 & UDB email list listserv db2-l LazyDBA home page