Home Toolbox Gallery

Software
Scripts
General Computing
GNU/Linux
Microsoft
BSD
C#/.NET
C/C++
PHP
SQL

MS Access Connection Strings MSSQL Case Sensitivity MySQL Root Password Reset MySQL Check Slow Queries Column Counting Quick Note on CROSS JOIN Quick Note on INNER JOIN Random Rows

HTML
JavaScript
Java
CSS
Electrical
RC Hobby
Gaming

Dag J Nedrelid
System and web developer.
Tech hobbyist. Dad. Gamer.
Mail:

Thronic.com content is FREE. Monetary support is optional.

Quick Note on CROSS JOIN

By Dag, on December 30th, 2016

Example:
If you want to retrieve a last row of information from a table, you could search for the max/highest row ID that has been created in that table to be sure that you are working against the latest one.

"SELECT tblOne.* FROM tblOne, (SELECT MAX(ID) as maxID FROM tblOne) maxresults WHERE tblOne.ID = maxresults.maxID"

When you need a subquery in 1 query it's called a CROSS JOIN.