So frackin hard

CREATE TABLE EMPLOYEE3 AS
   (SELECT PROJNO, PROJNAME, DEPTNO
    FROM EMPLOYEE
    WHERE DEPTNO = ‘D11′) WITH NO DATA

MUST USE "WITH NO DATA"  at the end of statement - bullshit fibm

This entry was posted on 28. January 2010 at 22:05 and is filed under SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response or trackback from your own site.