Joining of data not working

I have a query which references Google Analytics data - this is working fine.

Screenshot 2020-04-27 at 12.52.12

I have a query which references MySQL data - this is working fine.

Both of the above return userid.

When I do a join across these two it doesn’t match any data.

Am I doing something wrong?

Thanks

Two potential causes:

  1. One or both of the userid fields includes whitespace characters so the JOIN fails.
  2. You might need to CAST both userid fields to a common type. I don’t recall if SQLite can JOIN "1234" and 1234 by default. In most languages that equality check would fail.

This did it - needed to CAST - thank you!

1 Like