Help with a multiple table query

From: Dave Lugo (DaveLugo_at_discussions.microsoft.com)
Date: 11/04/04

  • Next message: Hugo Kornelis: "Re: Help with a multiple table query" 
    Date: Wed, 3 Nov 2004 20:00:03 -0800

    Hi,

    I need help in constructing a query against my Db I have. The DB I have has
    122 Tables and 15 columns in each. I have information in a column in one
    table that I need to query with data in a column on another table. In other
    words, In Table ad, i have a column called ENTRY_ID that I want to query
    against data in the column PUBLISH_DATE in table INSERT.

    This is what I have so far.

    select a.ad_number,a.entry_date,b.publish_date
    from ad a, ad_insert b where a.entry_date = '2004-11-03'and b.publish_date =
    '2004-11-04'

    I know I have records but the query produces no results so
    any help on what I am missing would be greatly appreciated.

  • Next message: Hugo Kornelis: "Re: Help with a multiple table query"