空值查询 量词谓词（Null query quantifier predicate）.docVIP

空值查询~量词谓词（Null query ~ quantifier predicate） * identifying purchase orders not yet determined by suppliers Select * from supplier isnull (supply firm) =.T. Select * from supplier where isnull (supply firm) =.T. USE f:\ fourth chapter commonly used table \ supplier.Dbf EXCLUSIVE Close all USE f:\ fourth chapter commonly used table \ supplier.Dbf EXCLUSIVE BROWSE LAST Select * from order form where isnull (supply firm) =.T. Select * from order form where supply firm is null * in VF,.NULL. is used to represent null values; In SQL, null values are represented by is null * note that when you deny null values inside SQL, you use is not null instead of isnt null. Select * from order sheet, supply firm isnt null Select * from order sheet, supply firm is not null Select * from order form where supply firm is not null Select * from order form where supply firm isnt null Select warehouse number, area, salary, from warehouse, staff where, employee number = E3 Select warehouse. Warehouse number, area, salary, from warehouse, staff where, employee number = E3 Select warehouse. Warehouse number, area, salary, from warehouse, staff where, employee number = E3, and; Warehouse. Warehouse number = worker. Warehouse No. Select A. warehouse number, area, salary, from warehouse, a, staff b where, employee number = E3, and; A. warehouse number =b. warehouse number Select A. warehouse number, area, salary, from warehouse, as a, staff as, b where, employee number = E3, and; A. warehouse number =b. warehouse number * setting aliases can use as or spaces * function: simplify operation,; For multiple tables, connection queries Select gy. employee name, as manager, leader, jl. employee name, as employee, from employee, as Gy, employee as jl; Where gy. employee number =jl. Manager Select gy. employee name, as manager, leadership, as relationship, jl. employee name, as employee, from employee, as Gy, employee as jl; Where gy. employee number =jl. Manager * employee as Gy, employee as JL: a table