Problem: Table A: "Categories" [CategoryId] [CategoryName] [CategorySuperId] Table B: "Items" [ItemId] [CategoryId] [ItemName] [DateAdded], Now I would like to select, the latest added items of a group of subcategories where supercategoryid=.. can someone give me a hint, or the basic structure of the sql query I should use?
Thanks in advance

SELECT i.ItemId, c.categoryId
FROM Items i, Categories c
WHERE i.CategoryId = c.CategoryId
AND i.DateAdded > '2003-11-19'
AND c.CategorySuperId = X;