On Wed, 14 Jul 2021, Adrian Klaver wrote:
Where are c.nbr and a.* coming from? If they are supposed to be table
qualified values this will not work.
Adrian,
From the psql shell version.
Also it is sql.Identifier.
Thanks; I certainly missed that.
This will not work, if for no other reason that 'companies as c on
c.org_nbr = p.org_nbr', etc are not identifiers and it is sql.Identifier.
Also it would be simpler for this case just to create a quoted statement,
something like:
"""SELECT
fld_1, fld_2, fld_3
FROM
some_table AS st
JOIN
another_table AS a
ON
st.id = a.a_id
WHERE
st.fld_1 = 'something'
"""
Got it, thanks.
Sorting out the proper format for my queries will take a bit of time. You've
helped shorten the time frame.
Regards,
Rich
