Edit Question

Title Body

I have first database (dbA) with table like this, named Username : +------------------+--------------+ | Username | PhoneNumber | +------------------+--------------+ | jamesbond007 | 555-0074 | | batmanbegins | 555-0392 | +------------------+--------------+ then, on the other side, I have dbB with table like this, named PrivateMessage : +------------------+---------------------------------+ | Username | Message | +------------------+---------------------------------+ | jamesbond007 | I need new bond-girl | | batmanbegins | thanks for the paycheck, Nolan | +------------------+---------------------------------+ now, how to combine this two tables from 2 different databases so the output will look like this : +------------------+--------------+---------------------------------+ | Username | PhoneNumber | Message | +------------------+--------------+---------------------------------+ | jamesbond007 | 555-0074 | I need new bond-girl | | batmanbegins | 555-0392 | thanks for the paycheck, Nolan | +------------------+--------------+---------------------------------+

Tags (comma-separated) Cancel