t-sql joins help

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Will something like this do what you need?

SELECT

Material.Name,

MfgDate,

MAX(StoredDate) AS StoredDate

FROM

Material

LEFT OUTER JOIN Store

ON Material.ID = Store.ID

AND StoredDate > MgfDate

GROUP BY

Material.Name,

MfgDate ;

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon