Post reply

Select Distinct

  • February 22, 2002 at 4:00 am

    #158165

    Hi all,

    I have a table [paper] with the columns,

    [paper_id(key,identity)][name][style][weight]...

    The [name] column contains paper types e.g (Graphomatt,Mediaprint GI). These paper types are repeated but I need only one of each to put in a select box.

    Any ideas?

    Wade Montague

    Edited by - wade on 02/22/2002 04:00:36 AM

  • February 22, 2002 at 4:25 am

    #424316

    SELECT DISTINCT [name] FROM [paper]

    Unless there is something I don't get here.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • February 22, 2002 at 4:46 am

    #424322

    sorry me being a muppit.

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

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