Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
OldMySQLUser
Constraint Violating Yak Guru
301 Posts |
 Posted - 2008-01-20 : 12:21:38
|
| I only come into contact with database work occasionally, hence the simplicity of my question for the majority of you, but I currently have a database to work with which consists on 15 tables. The only commonality between these tables is two columns: customer_number and transaction_date. I need to construct an audit trail scenario, where the user enters the customer number and a list of all transactions, in date order, pertaining to that customer streams into a web table (PHP created) from all the tables to hand.I'm looking for advice please regarding how to go about bringing these tables together. JOIN? Any ideas gratefully received. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-20 : 12:36:49
|
| i think you might need a trigger to achieve this. can you explain more on your scenario? |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-20 : 13:04:04
|
| create a view that returns same data from all tables which are unioned toghether and order by the transaction date._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
|
|
|
Workflow advice