F
foghat
Hi all,
I have a Access database that is linking to Oracle tables.
I need to join on two different data types. Number and Varchar2.
With a oracle query, it is easy: one can simply put a to_char on the number
data type. So:
select *
from invoice i, comment c
where to_char(i.invc_id) = c.reference_id
However, I can't see any way to do this with the Access query (in either
Design View or SQL View).
Is this possible?
I have a Access database that is linking to Oracle tables.
I need to join on two different data types. Number and Varchar2.
With a oracle query, it is easy: one can simply put a to_char on the number
data type. So:
select *
from invoice i, comment c
where to_char(i.invc_id) = c.reference_id
However, I can't see any way to do this with the Access query (in either
Design View or SQL View).
Is this possible?