Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

sql statement help

Discussion in 'Information Technology' started by James, Jul 28, 2006.

  1. James

    James
    Expand Collapse
    Guest

    I need help with a basic sql statement

    I want to select an OfferingID matched with its respective ReleaseName
    from qOfferings_Display

    OfferingID is unique, ReleaseName is not

    I figured it was SELECT OfferingID ______ ReleaseName FROM
    qOfferings_Display

    what goes in the blank? thanks
     
  2. Loading...


  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "James" <jamesburkett@gmail.com> wrote in message
    news:1151351346.176341.226050@c74g2000cwc.googlegroups.com
    > I need help with a basic sql statement
    >
    > I want to select an OfferingID matched with its respective ReleaseName
    > from qOfferings_Display
    >
    > OfferingID is unique, ReleaseName is not
    >
    > I figured it was SELECT OfferingID ______ ReleaseName FROM
    > qOfferings_Display
    >
    > what goes in the blank? thanks


    if qOfferings_Display joins the two tables involved on the OfferingID
    field in both, then all you really need in that blank is a comma:

    SELECT OfferingID, ReleaseName FROM qOfferings_Display

    If that doesn't work, then post the SQL of the query and we should be
    able to work it out.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     

Share This Page