Post reply

SQL Query question for school project

  • December 12, 2008 at 3:40 am

    #911528

    try,

    SELECT Company.[Company Name], DailyStockPrice.Date

    FROM Company LEFT OUTER JOIN DailyStockPrice ON Company.[Ticker] = DailyStockPrice.[Ticker]

    WHERE DailyStockPrice.Date IS NULL

    GROUP BY Company.[Company Name], DailyStockPrice.Date;

  • January 12, 2009 at 6:49 am

    #925228

    Access will create this kind of query for you - create a new query and choose the "Find unmatched query wizard" from the menu, then follow the prompts

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

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