home
Basic SQL queries for Jet SQL, Paradox, dBase



themedate
Worth a look: Database normalization explained in simple manner2014-07-24
Basic SQL DDL for MS-Access2003-11-04
Basic SQL DDL for Paradox, dBase2003-11-04
SQL queries syntax for desktop DBMS2003-08-21
Limit number of records returned by SELECT2004-02-01
Two ways to save query results into table2010-09-29
Query with user defined parameters2004-06-14
Simple uses of String functions CHR() and ASC()2005-01-18
Simple uses of String functions MID() and UCase()2008-11-27
Using wildcards in MS-Access LIKE function. 12009-07-16
Using wildcards in MS-Access LIKE function. 22011-02-28
Using list of values as condition in WHERE clause2011-04-01
VBA FORMAT() time function2007-08-28
Format mailing address using Mid and InStr functions2004-06-14
Create empty copy of existing table2004-06-14
Save table/query into table in external Database file2012-05-14
Subquery Examples2012-05-18
To use DISTINCT everywhere is a bad habit2005-12-05
Write condition in WHERE clause instead of HAVING2005-12-05
SQL datatype formats for desktop DBMS2003-11-04
ASCII Character Set2003-10-10
Using Inner Join 2005-09-23
Using Outer Join 2005-09-23
Simple join between two tables2009-04-12
Order list of names by second word2011-02-04
Cartesian join between two tables2007-11-16
Get random number using Rnd() function2008-05-25
Deal with dates in Query condition2009-12-03
Convert Character value to Integer2010-02-21
Create Indexed Table2011-04-10


sqlexamples.info