我们有三个表:播客(podcast_id,标题),评论(podcast_id,rating,review_title,author_id)和类别(podcast_id,category)。当我加入这些表时,我得到了两次播客和评论,因为在categories表中,一些podcast_ids列出了两次,因为它们有两个对应的类别。这是我目前正在运行的查询: SELECT podcasts.title AS podcast,reviews.title AS review
SELECT hh_podcast_channel.idinner JOIN ( ROW_NUMBER() OVER(PARTITION BY hh_podcast_episodes.id ORDER BY hh_podcast_episodes.published_on) as rn
FROM hh_<