All pastes #507639 Raw Edit

query compilation

public text v1 · immutable
·published 2007-05-24 17:36 UTC
rendered paste body
I am trying to make this query work:

select ARPLOG.* from ARPLOG where WHEN_ADDED > DATE_SUB(current_date(), interval 3 month) left join dhcpd on ARPLOG.MAC_ADDR=dhcpd.MAC_ADDR where dhcpd.MAC_ADDR is null;

From these working queries:

select ARPLOG.* from ARPLOG left join dhcpd on ARPLOG.MAC_ADDR=dhcpd.MAC_ADDR where dhcpd.MAC_ADDR is null;

select * from ARPLOG where WHEN_ADDED > DATE_SUB(current_date(), interval 3 month);