There are two list
A table:
Some other data + obsid (bigint)
Table B:
Some other data + obsid (bigint)

When I use the join obsid as key link two tables can not match, I again with
The select obsid from a where clause obsid (in the select obsid from b)
Do the test and found the return value is null,

Then I use the
Select * from a join b on cast (a.o bsid as int)=cast (b.o bsid as int)
Successful match,
Bullish from the phenomenon like bigint type in a sqlite data cannot compare, only to become an int type to match?
I use sqlite studio direct observation don't see what is the difference between the two tables obsid,
Does anyone know what this is?