I hope someone can help me!
I have 'payment' data in two databases. One db contains old/archived data. Each db contains the exact same table "PmtsTbl" but obviously the data is different.
I want to select all payment data from both db within a date range. I have the following sql which works in "Mysql Workbench"
Code:
SELECT * FROM (SELECT * FROM DB1.PmtsTbl
Leave a comment: