got error massage "ORA-00942"  for creating table with select statement from multiple DB

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