public static void create(Statement stmt) {
        String createRegister = "CREATE VIEW Register AS " +
                "SELECT "+
                    "ToolID, Engraved, OldID, Tools.Description, Make, Model,"+
                    "DivisionCode, Divisions.Description as DivisionDescription,"+
                    "TeamID, UserName, Quantity, DatePurchase, Status,"+
                    "ConditionCode, Conditions.Description as ConditionDescription,"+                
                    "LocationCode, Locations.Description as LocationDescription,"+
                    "Supplier, Price "+
                "FROM Tools,Divisions,Locations,Conditions WHERE "+
                "DivisionCode = Divisions.Code"  + 
                " AND "+                
                "LocationCode = Locations.Code"  + 
                " AND "+
                "ConditionCode = Conditions.Code"
                ;
        
        try {
            stmt.executeUpdate("DROP VIEW IF EXISTS Register");
            stmt.executeUpdate(createRegister);
            
        } catch (SQLException ex) {
            ex.printStackTrace();
        } 
    }