Guest_imported
New member
- Jan 1, 1970
- 0
I get an error ("Join expression not supported."
with the following query:
I get no error with a simplified query on made-up tables:
Can I not LEFT JOIN on x AND y when x and y are in different tables, or am I missing something else? If not, I could use some help with a workaround.
with the following query:
Code:
SELECT DISTINCT [False Positives].[IP Address], Hosts.ipAddressStr, [False Positives].vulnID, VulnsFound.vulnID
FROM ((Jobs INNER JOIN VulnsFound ON Jobs.jobID=VulnsFound.jobID)
INNER JOIN Hosts ON Hosts.hostID = VulnsFound.hostID)
LEFT JOIN [False Positives] ON ([False Positives].[IP Address] = Hosts.ipAddressStr AND [False Positives].vulnID = VulnsFound.vulnID)
WHERE Jobs.jobID=348 AND [False Positives].[IP Address] IS NULL
ORDER BY Hosts.ipAddressStr;I get no error with a simplified query on made-up tables:
Code:
SELECT DISTINCT Omit.IP, Found.IP, Omit.vuln, Found.vuln
FROM Found LEFT JOIN Omit ON Found.vuln=Omit.vuln AND Found.IP=Omit.IP
WHERE Omit.vuln IS NULL
ORDER BY Found.IP;Can I not LEFT JOIN on x AND y when x and y are in different tables, or am I missing something else? If not, I could use some help with a workaround.
