Skip to main content

join dua database

March 26, 2010 by cah_ajus

cah_ajus's picture

helppppp me........................
saia mo tanya, bagaimana caranya melakukan perintah join di dua database (bukan dua tabel)
misalnya saya punya database_1 dengan tabel master kemudaian ingin saya join dengan databse_2 dengan tabel anak, bagaiman proses joinnya????tlongin donkkkkkkkk..............

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

join dua database

September 16, 2010 by sirgobang, 1 year 4 weeks ago
Comment: 7129

sirgobang's picture

SELECT *
FROM database1.table1 as 'pertamax'
LEFT OUTER JOIN database2.table1 as 'keduax' ON pertamax.id=keduax.id

semoga dapat membantu

Premium Drupal Themes by Adaptivethemes