Link to home
Start Free TrialLog in
Avatar of sakthikumar
sakthikumar

asked on

invalid number error

Table1 has values 12345 and 1234
and table2 has one value 12345,1234

When i try to use the following query: am getting invalid number.
select * from table1 a, table2 b
where a.tablecol1 in (b.tablecol)

any other way to execute this.
ASKER CERTIFIED SOLUTION
Avatar of Rajkumar Gs
Rajkumar Gs
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sakthikumar
sakthikumar

ASKER

Thank you, nice suggestion from both of you.