I have two tables in an MS SQL database.<BR><BR>Table1<BR>Date, group, volume<BR>Table2<BR>Date, group, volume<BR>What I need is to divide the volume for a particular date in Table 2 by the sum of ...

The subselect portion of the WHERE clause is completely self-contained, so I don’t have to use fully qualified column names such as Album.song_name and Lyric.song_name.