using sqldf to join two data frame but result is converting from Int to Logical

[Musketeers]

Hi, I am doing left join of two data frame using sqldf library. Why instead of field value from right table, I am getting logical value from that field.
I can see that both are dataframe using STR function and the joining field is Region present in both data frame.
The field which I need from right dataframe is Integer data type as shown by STR function.
But after joining I can see that final datfarme has this field as Logical data type.
Why the datatype is changed from Integer to Logical.
Have any one faced such situatuion or I am doing some thing wrong.
Please let me know what I should do for this to correct it.

Thanks
Rajneesh

[jdlong]

if you want any help with this you'll need to create a reproducible example (reprex). My guess is that you are likely doing a comparison instead of a join but it's hard to guess.

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…