#1 2022-10-17 15:42:52

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

Offline

#2 2022-10-17 16:43:25

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
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?

Offline

Board footer

Powered by FluxBB