access语法大全（Access grammar）.docVIP

access语法大全（Access grammar） Access grammar Like query * SELECT * FROM flash WHERE filename like*http*; DELETE * FROM company_guangxi WHERE name not like name * * company and not like * * mechanism factory; Delete query DELETE * FROM order WHERE order. Order date =#1/1/2002# Update query UPDATE products SET products. The price = [MSRP]*1.2 = MOTOROLA WHERE. Access SQL statement query Generate serial number when querying SELECT (SELECT, Count ([xlh].[aa]), AS, AutoNum, FROM, XLH, WHERE (((xlh.aa) =xlh_Alias.aa)); AS ordinal number, xlh.aa FROM, XLH, AS, xlh_Alias, INNER, JOIN, XLH, ON, xlh_Alias.aa=xlh.aa ORDER BY xlh.aa; Multi table SQL query SELECT test.aa AS, the first field, test1.bb AS, second fields, test1.cc FROM, test, test1 WHERE test.aa=test1.aa; Multi table SQL query 1 SELECT, a.aa, b.bb, b.cc, b.cc*100, AS total FROM, test, AS, a, test1, AS, B WHERE a.aa=b.aa; Multi table SQL query sorting SELECT, a.aa, b.bb, b.cc, AS, third fields FROM, test, AS, a, test1, AS, B WHERE a.aa=b.aa ORDER BY b.cc; Query example SELECT a.dhhm FROM, xl11a, AS, a, xl919, AS, B WHERE a.dhhm=b.dhhm and AA 1; Date time separator is # instead of single quotes Select * From, Tab1, Where, [Date]#2002-1-1#; Function and calculation Aggregate groups, expressions and conditions SELECT orders. The customer number, Sum (order tax price) AS total tax price, Last (order. Order date) AS order date at the end of a pen, (Date) - order date of last AS days FROM WHERE (from orders order date order. =#12/1/2006#) GROUP BY orders. Customer number 11-2 query instruction group condition Multiple calculation fields Multiple data table query instruction The most basic JOIN way of INNER JOIN- SELECT customer. Company name, order, order number, order, order date, FROM customer, INNER JOIN order, ON customer number, customer order = order number 11-2 query instruction Multiple data table query instruction LEFT and RIGHT JOIN SELECT customer. Company name, customer, contact name, order number, customer num