SELECT required columns....
FROM Table1 t1
INNER JOIN Table2 t2
ON t.messageid=t2.messageid
AND t2.username = @yourpassedusername
LEFT JOIN Table3 t3
ON t3.messageid = t2.messageid
AND  t3.username = t3.username
WHERE t3.messageid IS NULL
AND t1.publishdate > = DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0) 

quote:

---

Originally posted by teddymeu4u

Hi visakh16 thanks for the reply, however im looking for items where the user hasnt already read them, maybe if i give you the table structures youll get a better idea.

Table 1
MessageID (int PK)
title (varchar200)
Created (smalldatetime)
PageURL

Table2
MessageID (int)
MU_ID (int)
Site (varchar)

Table 3
messageID (int)
username (varchar11)
readit (smallint)

Ok, so i want to know, all articles for the username, where the created date is greater than or equal to todays date, and the username and message id, doesnt appear in table 3, i am passing in th username, site, and MU_ID, in the query string as parameters.

Thanks

No one ever said it was going to be easy, then again, nothing worth doing ever is.

---

SELECT required columns....
FROM Table1 t1
INNER JOIN Table2 t2
ON t.messageid=t2.messageid
AND t2.username = @yourpassedusername
LEFT JOIN Table3 t3
ON t3.messageid = t2.messageid
AND  t3.username = t3.username
WHERE t3.messageid IS NULL
AND t1.publishdate > = DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0)
AND  t1.username = @User
AND site = @site 
and MU_ID = @MUID