How do I grab two database record and display them on a single go? For example I'm trying to draw two database userid + password.
1. Database01 - table name: user - column: userid/password
2. Database02 - table name: user - column: userid/password
Can I use view to pull both of the tables from different database and put them on a single SQL command? I tried but it keep coming with INNER JOIN function which I don't need. Any suggestions?