Hi All,
I don't know why I always got error massage "ORA-00942" while passing through the following query to Oracle via ODBC
create table table_AB as(
select
Customer_ID,
Customer_Name,
Order_Number,
Order_Date
from
Customer_Table
left join Order_table@Order_DB on Order_table.customer_id = Customer_table.customer_id
);
Note: both database are linked at the server side. However, I am using a third party BI tools to while executing the query and that BI tool is connect to the DB that stored the Customer_Table via ODBC.
Both table is available from both database.
Thanks a lot