Author:
erics, May 16th, 2018
SELECT t1.id FROM tableOne t1 LEFT JOIN tableTwo t2 ON t1.id = t2.id WHERE t2.id IS NULL The “WHERE t2.id IS NULL clause” restricts the results to only those rows where the id returned from tableTwo is null. tableTwo.id will be NULL for all records from tableOne where the id is not found in tableTwo.
Categories: How-To's, Technology Tags: howto, Join, Left Join, mysql, Query, Row, Rows, select, SQL, Table, tips, Where
| 
No comments
Author:
erics, August 29th, 2013
window.location.href.split(‘?’)[0]
Categories: How-To's, Technology Tags: howto, javascript, Query, Query String, tips, URL
| No comments
Author:
erics, February 25th, 2012
This query will list the names of the reports in the database: SELECT MSysObjects.Name AS Report_Name FROM MSysObjects WHERE (((MSysObjects.Type)=-32764)) ORDER BY MSysObjects.Name; This query will list the names of the queries in the database: SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=5)); This query will list the names of the tables in the database: SELECT MSysObjects.Name […]
Categories: How-To's, Technology Tags: Access, Export, howto, MS Access, Queries, Query, Reports, tips
| No comments
Author:
erics, October 14th, 2011
1 2 3 4 5 6 SELECT @rownum := @rownum + 1 AS Rank, T1.* FROM (select @rownum := 0) R, ( SELECT Category, Item, Value FROM Inventory WHERE lastUpdated = CURDATE() ORDER BY Value DESC ) AS T1 WHERE T1.Item = "Camera" SELECT @rownum := @rownum + 1 AS Rank, T1.* […]
Categories: How-To's, Technology Tags: howto, Line number, mysql, Query, Row number, Sequence number, sort, SQL, tips
| No comments
