>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.
Instead of B!Price use path&filename of second table.
Cetin