"SELECT stock FROM product_in_stock"

[oxido]

how can I change the  "SELECT stock FROM product_in_stock" in virtuemart 2?
What i want to do is to import into VirtueMart stock from another database, not realy import...
I want VirtueMart to display stock from another database.

I am interested to find where is that "SELECT * FROM products" in connection with the stock, can someone help me please?

[oxido]

nobody can give me any indication?   

[vigier]

My knowledge of MySQL isn't that good, but my SQL Server knowledge is.
How I would do it in SQL Server: create a view that select from another database. Then change your select statement to use the view instead of the table.

The view would have a query like "SELECT stock FROM otherdatabasename.stocktable".
Your query would be like "SELECT stock FROM nameofyourview"