I have two databases and each database has myTable like the above.
myTable in db1
myTable in db2
I made the following would-be code for getting my target result below.
The would-be code above doesn't work correctly.
<cfquery datasource='db1,db2' name='db2'>
order by id
How can I get my target result?