CREATE VIEW set1 AS SELECT field1,field2,field3 FROM table WHERE data_set = 'set1'; CREATE VIEW set2 AS SELECT field1,field2,field3 FROM table WHERE data_set = 'set2';