AND Cover.song_name = Album.song_name); In the SQL code, I used fully qualified column names because I’m directly comparing the two tables, not merely using the result set as a passive resource.

The outer PROC SQL query retrieves data from the view descriptor; the subquery uses a Pass-Through query to retrieve data. This query returns the names of employees who earn less than the average ...

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.