Describe the bug
When making a query using INNER JOIN:
❯ stackql exec "SELECT alarms.region, alarm.alarm_name FROM awscc.cloudwatch.alarms AS alarms INNER JOIN awscc.cloudwatch.alarm AS alarm ON (alarms.alarm_name = alarm.alarm_name) WHERE alarms.region = 'ap-southeast-2'";
we get the following error:
alias 'alarms' does not map to any table expression
When amending the query like so:
❯ stackql exec "SELECT region, alarm_name FROM awscc.cloudwatch.alarms AS alarms INNER JOIN awscc.cloudwatch.alarm AS alarm ON (alarms.alarm_name = alarm.alarm_name) WHERE region = 'ap-southeast-2'";
we also get a different error:
unknown key ResourceDescription
To Reproduce
Steps to reproduce the behavior:
run the queries above
Expected behavior
Able to join 2 separate provider resources
Screenshots
N/A
Desktop (please complete the following information):
OS: MacOSX
CLI
Smartphone (please complete the following information):
N/A
Describe the bug When making a query using INNER JOIN:
we get the following error:
When amending the query like so:
we also get a different error:
To Reproduce Steps to reproduce the behavior:
Expected behavior
Screenshots N/A
Desktop (please complete the following information): OS: MacOSX CLI
Smartphone (please complete the following information): N/A
Additional context N/A