Question about Joining -- Query JSON with SQL

Queries and Resources
1

Hello!

I am attempting to join data from two database resources using "Query JSON with SQL." It's my understanding the syntax should be AlaSQL.

My use case requires the join matches on values from two columns. The syntax described here seems familiar enough. Unfortunately, even though my values match, the JSON with SQL query returns 0 rows. But, if I use one column in the join - either column - the query returns data. I've limited the resource data to one row to make troubleshooting easier.

This query returns no results.

SELECT *
FROM {{queryTasks.data}} AS qt
JOIN {{queryCombineInputRecords.data}} AS cir 
ON qt.RecordNumber = cir.RecordNumber
AND qt.CustomerNumber = cir.CustomerNumber

This query returns results

SELECT *
FROM {{queryTasks.data}} AS qt
JOIN {{queryCombineInputRecords.data}} AS cir 
ON qt.RecordNumber = cir.RecordNumber
--AND qt.CustomerNumber = cir.CustomerNumber

So does this one

SELECT *
FROM {{queryTasks.data}} AS qt
JOIN {{queryCombineInputRecords.data}} AS cir 
-- ON qt.RecordNumber = cir.RecordNumber
ON qt.CustomerNumber = cir.CustomerNumber

A screenshot of the action below.

image
image605×791 37.8 KB

I assume I've made some syntax error. Thanks in advance.

2

I found a different syntax that works.

SELECT *
FROM {{queryTasks.data}} AS qt
JOIN {{queryCombineInputRecords.data}} AS cir 
USING RecordNumber, CustomerNumber

Hopefully this is useful for someone else!