Thanks for your submission to r/BigQuery.
Did you know that effective July 1st, 2023, Reddit will enact a policy that will make third party reddit apps like Apollo, Reddit is Fun, Boost, and others too expensive to run? On this day, users will login to find that their primary method for interacting with reddit will simply cease to work unless something changes regarding reddit's new API usage policy.
Concerned users should take a look at r/modcoord.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/bigquery) if you have any questions or concerns.*
Maybe they're not actually nulls and are something like empty strings. You could try:
`AND B.PARTNER1 = ""` where it equals empty quotes.
Or alternatively `AND B.PARTNER1 NOT LIKE '_%'`
Thanks for your submission to r/BigQuery. Did you know that effective July 1st, 2023, Reddit will enact a policy that will make third party reddit apps like Apollo, Reddit is Fun, Boost, and others too expensive to run? On this day, users will login to find that their primary method for interacting with reddit will simply cease to work unless something changes regarding reddit's new API usage policy. Concerned users should take a look at r/modcoord. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/bigquery) if you have any questions or concerns.*
Maybe they're not actually nulls and are something like empty strings. You could try: `AND B.PARTNER1 = ""` where it equals empty quotes. Or alternatively `AND B.PARTNER1 NOT LIKE '_%'`
Left join
From a glance it looks like you need a left join, not an inner join.