I am new to Google Big-query, I want to extract post title,post body,comments, score and the creation date from the database for all posts that are created on or after 2010 for a subreddit, for now I have been able to query all subreddit comments using
SELECT * FROM `pushshift.rt_reddit.comments` WHERE lower(subreddit)="politics"
But my motive is to join the comments and posts table in order to generate the required results but I am not able to find how to do this, how can that be achieved? Please let me know if any further details are required. Thanks