Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro! Do you ever find yourself juggling queries to get the information you need?

As in summary. Consider following database: create table a_table(id integer primary key, a_column varchar(32) not null, another_column varchar(32)); create alias a ...

</pre><BR><BR>Can I do this? Basically what I'm trying to accomplish is the following. I have two tables in an MS SQL database.<BR><BR>Table1<BR>Date, group, volume<BR>Table2<BR>Date, group, ...