i have a Q that for a time make me angry!
*************************************
table1 is like this :
id name
-----------------
1 jack
2 smith
3 david
4 ....
pk is [id]
*************************************
table2 is like below :
Userid date text
--------------------------------------
1 2007-10-11 aaaaaaaaaaaaaa
2 2007-10-11 bbbbbbbbbbbbbb
1 2007-10-13 cccccccccccccc
**************************************
in this table pk is [id+date] and fk is [Userid] that refered to id of table1
it means that we can`t have the record like :
1 2007-10-11 CCCCCCCCCCCCCC
(duplicated record!)
and the problem is :
i want to know for a limit of date(like from 2007/1/1 till 2008/1/1) which records doesn`t be in table2.for example answer can be like this:
table3 (result table)
Userid date
---------------------
2 2007-10-13
by just using of sql , can i find my answer table(table3)?
tnx.
