cross-join Questions

Postgresql – How to convert cross join lateral statement to big query?

August 10, 2023
Learn Hadoop
2 Answers

My sql statement is written using cross join lateral in postgres sql. But i want to execute this sql statement in google bigquery and bigquery doesn't support cross join lateral. How can i rewrite this sql for bigquery engine? select…

VIEW QUESTION

Postgresql – What is wrong with this JOIN syntax?

September 23, 2022
Bud
2 Answers

If I run this SQL code in my PostgreSQL database, it works fine: select e.type_id, s.copy_destination || '' FROM ebooks.ebooks e, ebooks.static_text s WHERE e.status_id = 1 But when I add the join, everything goes pear-shaped. So if I run:…

VIEW QUESTION