Dear all,
Has anyone create a heterogenous query in Toad query builder? I created a query
to join Excel source and an Oracle table.
When I run query on each table individually, it runs without error, but once i
start joining them, the query gives me an error. Any thoughts? Could any Toad
experts shed some light on how to join Excel to Oracle N tables via Toad in
details?
SELECT EVENT_REASON_DOMAIN.EVENT_REASON
, EVENT_REASON_DOMAIN.W_EVENT_SUBG_CODE
, EVENT_REASON_DOMAIN.Action Code
, EVENT_REASON_DOMAIN.Action Desc
, EVENT_REASON_DOMAIN.Action Reason Code
, PS_ACTN_REASON_TBL.DESCR
FROM
`C:\Documents and
Settings\pxc5170\Desktop\domainValues_Emp_EventType_SubG_Code_psft.xlsx`.EVENT_REASON_DOMAIN
EVENT_REASON_DOMAIN
INNER JOIN
{{Odbc("DRIVER={Microsoft ODBC for
Oracle};SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.40.8.89)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=HRDEV91)));UID=PXC5170;PWD={0};,603812773F20A08F")}}.“SYSADM.PS_ACTN_REASON_TBL”
PS_ACTN_REASON_TBL
ON (CVAR(EVENT_REASON_DOMAIN.Action Reason Code) =
CVAR(PS_ACTN_REASON_TBL.ACTION_REASON));
Thank you in advance,
L
