Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Query to MySQL and Sybase at once


anree

Recommended Posts

Hi all! Sorry for my English because i from Ukraine.

I use my OSC with MySQL data base. But i want load products data and quantity from Sybase Database. I connected to Sybase via ODBC. This is easy. But i have problem when i need use query something like that:

ODBC - Sybase database

MySQL - MySQL Database

 

"select * from ODBC.products LEFT JOIN Mysql.products_description where odbc.products.id = mysql.products.products_id"

 

Please help me!!! How i can use one query to two different database?

 

In russian and ukrainian forums i didn't find any information :-(

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...