This method isn't ANSI-standard SQL, but Microsoft's Transact-SQL extension includes this handy feature. Creating a new table from query results can help you build a database of your clients ...

I have a value that I want to do delete everything from a table that contains this value in a field. Also, each one of those that I delete has an ID that is a foreign key value in another table.

How could I construct a view which would pull data from each of 5 tables so that a report could be built against the one view?

Reindexing tables is an important part of good database housekeeping, because it reorganizes the indexes and restores speedy access. Microsoft's SQL Server has a handy command that rebuilds all ...