FROM '{join ...}' brackets in SQL binding query

Ignition
1

The following SQL runs fine in the Database Query Browser but will not work as a SQL query binding because of ‘{’ brackets on the join clause. What is the syntax one uses to get around this?

SELECT op_code_log.code, b_codes.the_type, form_header.form_number
FROM {oj op_code_log LEFT OUTER JOIN b_codes ON op_code_log.code = b_codes.code LEFT OUTER JOIN form_header ON op_code_log.form_serial_id = form_header.form_serial_id}

2

You don’t need the brackets in your query. Just remove them and it should be fine.

3

Thanks Travis. I also had to remove the ‘oj’ for it to work.