MuttleyDiXiE
MIS
Hi,
I'm new to SQL and can't seem to figure out how to create a SQL query that does want I want it to do.
I have a table "Nodedate" like this;
Node Date
TDCXTC1445 30-11-2003
TDCXTC1445 01-12-2003
TDCXTC1445 31-12-2003
ABN001111 30-11-2003
ABN001111 01-12-2003
ABN001111 31-12-2003
ABN001111 31-01-2004
TDCTDR1350 31-12-2003
TDCTDR1350 31-01-2004
What query will output all Node's with the date 30-11-2003 but not 31-12-2004? So from the table sample above the Node/Nodes returned would be TDCXTC1445.
I just can't get it!!!!! Someone please help...
Rune
I'm new to SQL and can't seem to figure out how to create a SQL query that does want I want it to do.
I have a table "Nodedate" like this;
Node Date
TDCXTC1445 30-11-2003
TDCXTC1445 01-12-2003
TDCXTC1445 31-12-2003
ABN001111 30-11-2003
ABN001111 01-12-2003
ABN001111 31-12-2003
ABN001111 31-01-2004
TDCTDR1350 31-12-2003
TDCTDR1350 31-01-2004
What query will output all Node's with the date 30-11-2003 but not 31-12-2004? So from the table sample above the Node/Nodes returned would be TDCXTC1445.
I just can't get it!!!!! Someone please help...
Rune