تفریق 2 جدول از هم ؟!

[green.reptile]

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.

[peyman1987]

Could you please explain a little more?
I didn't get what you want?

اگر ایرانی هستین فارسشی بنویسین بهتر بهتون کمک میشه.

[tabib_m]

فقط چون توی این سایت تازه واردی و به قوانین واقف نیستی جواب میدم :)


SELECT `t1`.`id` , `t2`.`date` AS `theDate` FROM `t1` , `t2` WHERE `t2`.`date` > '2007-1-1' AND `t2`.`date` <= '2008-1-1' AND `t1`.`id` NOT IN (SELECT `userid` FROM `t2` WHERE `date` = `theDate`) group by `theDate`,`id`

ببین جواب میده یا نه


موفق باشید.

[reza_rad]

i have a Q that for a time make me angry!
*************************************

table1 is like this :

id name
-----------------
1 jack
2 smith
3 david
4 ....

دوست عزیز به برنامه نویس خوش آمدید.
برای فعالیت در این انجمن قبل از هر کاری قوانین را مطالعه کنید:
http://barnamenevis.org/forum/showthread.php?t=51814
برطبق قوانین شما نباید fingilish تایپ کنید.
پس نوشته خود را اصلاح کنید.

باسپاس