Column "aliasing"

2002-11-12 Thread Mike Patterson
I would like to add a column in one of my tables that is an exact copy of (or alias) for another column, except that it has a different name. Why? I'm joining two tables that were previously separate and I want to use 1 main idexing column (e.g. the same numbering scheme). However a whole lot

Maintaining #'s between 2 databases

2002-11-04 Thread Mike Patterson
I have two databases (rt2 & jobs) and within each of these DBs tables that autoincrement email Ticket #'s and Work Request #'s respectively. I'm looking for the best way to maintain the numbers between the databases (e.g. if I had a rt2, jobs, then rt2 requests: rt2 issues ticket #1024, then jo