Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Arrow Unanswered: Problem with multi sql query

    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

  2. #2
    Join Date
    Nov 2003
    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;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts