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?

I'm working on a client site where they've provided a SQL Server 2005 database. We've implemented a "simple" search that allows users to run keyword searches. The tables are heavily normalized with ...

</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, ...