mORMot Open Source

jars

Member

Registered: 2015-05-15

Posts: 29

join SQL Fail

I would like to know why this simple join fails

SELECT a.PRODUCTTYPE, b.PRODUCTTYPE, a.REFERENCE, a.INVDATE, a.SECTOR,
FROM TABLEREF a JOIN TABLEREF b ON b.REFERENCE = a.REFERENCE
WHERE a.INVDATE = '27.06.2022' AND a.SECTOR = '7'
ORDER BY a.REFERENCE

Thanks in advance

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,655

Website

Re: join SQL Fail

Please define what "fails" mean in your case.

And please refine the information.
How do you execute this statement?
With which compiler? On which OS? On which DB? On which DB provider?