Normally, the table is supposed to contained 4 million rows, which was taking a ridiculous amount of time to load (10s of seconds), while the row count number is not that high. I am not sure what ...

Subqueries are a powerful feature in SQL that allow you to nest one query inside another. They are essential for simplifying complex database operations and improving query efficiency.

buiild a query that has Month Count (*) fields. then update. if Access says none updatable qruery then do a make table with the sql then update.<BR><BR>Or you could program the solution.

For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL query retrieves data from the view descriptor; the subquery uses a Pass-Through query to retrieve ...