How to merge two tables from two different database

Asked Feb 13 '20 at 10:13

Active Feb 13 '20 at 10:32

Viewed 42 times

I have two tables from two databases.

How can I merge those tables to get my data.

org table means organization table contains

(oid),
oname, 
address 
and some other things (oid is the unique key)

employee table contains

empid, 
name,
address 
and some other things (empid is the unique key)

oid is the only common thing in both tables.

I want to merge them and add a filter to both organization and employee name

My problem is both tables are from a different databases.

edited Feb 13 '20 at 10:32

Dharman

asked Feb 13 '20 at 10:13

Praveen Kumar

1

Merge how? Show us some sample table data and the expected result - all as formatted text (not images.) [mcve] is worth reading. – jarlh Feb 13 '20 at 10:14
___oid is the only common thing in both tables.___ Except that `employee` table does not have an `oid` column ?? – RiggsFolly Feb 13 '20 at 10:31
What does it have to do with PHP? – Dharman Feb 13 '20 at 10:31
@Dharman in the title they mention `mysqli` So I added that tag which does imply PHP also – RiggsFolly Feb 13 '20 at 10:32
@RiggsFolly The question looks like it meant MySQL database instead of mysqli code. – Dharman Feb 13 '20 at 10:33
@Dharman We may never truely know now – RiggsFolly Feb 13 '20 at 10:34

0 Answers0