I think you need to specify the attributes on which to join the two tables
SELECT
lrel_attachments_changes.attmnt,
lrel_attachments_changes.chg,
lrel_attachments_changes.id,
lrel_attachments_changes.last_mod_dt,
lrel_attachments_changes.persistent_id,
chg.chg_ref_num,
chg.status_symbol,
chg.tenant_name,
chg.id
FROM lrel_attachments_changes
JOIN chg ON chg.id = lrel_attachments_changes.chg
WHERE
chg.tenant_name = 'Flap'
Cheers,
Lindsay
------------------------------
Lindsay Estabrooks
Principal Consultant
IT-EDU Consultants
------------------------------
Original Message:
Sent: 09-29-2020 11:19 AM
From: Anabel Zuniga Alarcon
Subject: Repor attachemnts
Hi good day
Thanks for helping me, see I share my query
SELECT
lrel_attachments_changes.attmnt,
lrel_attachments_changes.chg,
lrel_attachments_changes.id,
lrel_attachments_changes.last_mod_dt,
lrel_attachments_changes.persistent_id,
chg.chg_ref_num,
chg.status_symbol,
chg.tenant_name,
chg.id
FROM
lrel_attachments_changes,
chg
WHERE
chg.tenant_name = 'Flap'
Regas.
Original Message:
Sent: 09-29-2020 02:25 AM
From: Brian Mathato
Subject: Repor attachemnts
Hi Anabel,
It looks like your join or where-clause is incorrect. Share the query that is returning the results and we might be able to assist you further
------------------------------
Kind Regards,
Brian
Original Message:
Sent: 09-28-2020 07:14 PM
From: Anabel Zuniga Alarcon
Subject: Repor attachemnts
Hi good afternoon
They could give me a procedure to get the information correctly
Tanks.
Regads