<h3>9.27.17</h3>
Relational set operators (select, project)

select and project (select != select clause, select == where clause)

statement (sentence) is the whole thing with clauses (commas) between

select * selects all

select only price less than $2.00 yields (rows)

Select only P_CODE = 311452 yards


H/w is to change the where conditions

select
  from
   where

statement = all clauses

from is clause is statement

project (selects which colums i want, the data itself)

//sql cmd// drop insert create select
Project Price

Project P_DESCRIPT and PRICE yields

Union wont look at one, but looks at two. The two better have
the same attributes. CRSE and CLS only compatible for union with
2 compatible. If 1 is in both with same values then it will throw away.