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 ...
* means that more than one payment can exist against the invoice. All the info is in the same table, and the relationship of the invoice to payment is by a transaction_no field. So, is there one table ...