I need some help in intergrating 2 databases as follows.
1) Database 1 contains the products manufacturing codes , manufacturer name and prices.(its zencart database)
2) Database 2 is from data providing ompany, this contains detail product descriptions, images link, products attributes, manufacturer name and codes but no product price or stock information.
I need to integrate both databases so that ustomer at my site can have a detailed presentation of the products.