- 4504 Views
- 5 replies
- 14 kudos
I would like to know why CROSS JOIN fails recognize columns
Whenever I apply a CROSS JOIN to my Databricks SQL query I get a message letting me know that a column does not exists, but I'm not sure if the issue is with the CROSS JOIN.For example, the code should identify characters such as http, https, ://, / ...
- 4504 Views
- 5 replies
- 14 kudos
Latest Reply
- 14 kudos
@CARLTON PATTERSON​ Since you have given an alias "tt" to your table "basecrmcbreport.organizations", to access corresponding columns you will have to access them in format tt.<column_name>in your code in line #4, try accessing the column 'homepage_u...
- 14 kudos