I have two websites that post news information. I just got a request to make a single page for one of the sites that shows the mixed results from both sites. They are located on the same server and the tables are close to identical, but I am having problems figuring out how to combine the two queries. The postings need to be sorted by date, title when all is said and done.
For arguments sake, a simplified form of the tables is
DB 1, TABLE Clips1 (PK_ID, DateToShow, Title, Description)
DB 2, TABLE Clips2 (PK_ID, DateToShow, Title, Description)
So the single query would hit both databases (usernames and passwords are different currently), or two queries and some kind of combination that would keep the date and titles sorted.