Hi All,

I have two datbases say A and B. There is a connection handle for
Database A as AHandle and connection handle for Database B is BHandle.


I need to get data from both the datbase using the select command
below.

SELECT * from A!Items INNER JOIN B!Price ON Items.Item_Key =
Price.Iem_key

If I write a SQL execute statement like SQLEXEC('AHandle',
sqlcommand, 'crsOut'). I get an error indicating table Price is not
present in Database A.

How will I accomplish the task either by SQLEXEC or using ODBC? Any
help on this matter is appreciated.

Thanks,
Smitha.