SQL Tables

Navigate back to home page
z/OS related collateral
Windows related collateral
SQL/mySQL related collateral
Link to code that can be used on websites.
Link to ASL Program Documentation
All our latest news
Contacting Abbydale Systems
Obtain product support/suggestions
https://www.abbydalesystems.com/Terms and con
General disclaimer
All about Abbydale Systems
How we got our company name
Our privacy policy
Our development strategy
Visit our guestbook


Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39

Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39

Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39

Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39

Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39

Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39
Name
Description

This is an example of how to count total records in multiple tables using selection criteria.

The tables must reside in the same database, but the table names can be different. You can also omit the selection criteria and get a total for the entire table.



How to add a last updated field to an existing table.

This is useful if your database system doesn't hold statistics. This will work regardless.



This is a list of all the counties in England prior to 1965's reorganisation.



This table contains a list of all the registration districts and counties in England prior to 1968

It can be used to obtain just a list of English counties by using the following SQL:

"SELECT DISTINCT County FROM 'tblDistrict'"



This is a list of all the world languages along with their ISO 639-1 two digit code.

If you need the three digit codes then we recommend Github



This is a SQL Table of all the counties (and Parishes) in the USA.




Page #1  


If you need any support or assistance with any of the code on this site
or
if you would just like to contact us, please click here

follow us on facebook
Follow us on Facebook






Subscribe to our YouTube Channel Subscribe to our YouTube channel


CBT Tape Home Page MVS and OS/390 Freeware Link to the CBT website


Copyright © Abbydale Systems LLC 2015-2026

Abbydale Systems LLC Lic. 802696149. All rights reserved.