Professional Web Applications Themes

Returning multiple values for unique key - Microsoft SQL / MS SQL Server

If you are doing a inner join on two tables and it produces multiple rows for a unique key, because other field values are different is there a way to grab the first row only?...

  1. #1

    Default Returning multiple values for unique key

    If you are doing a inner join on two tables and it
    produces multiple rows for a unique key, because other
    field values are different is there a way to grab the
    first row only?
    noon Guest

  2. #2

    Default Re: Returning multiple values for unique key

    noon wrote: 

    Sure - what is special about the first row that will allow the query to
    recognize it and select it as opposed to selecting any of the other rows in
    the group? You're going to have to provide some more information.
    CREATE TABLE scripts (only include the minimum number of columns to enable
    you to illustrate the problem) and insert statements for sample data, along
    with a tabular representation of what the query is supposed to spit out will
    go a long way toward getting this problem solved.

    Bob Barrows


    Bob Guest

  3. #3

    Default Thank you

    Thank you for your help
     
    may 
    by 
    ---- 

    columns>> 
    >
    >.
    >[/ref]
    noon Guest

Similar Threads

  1. Web Services: Returning unique values from queries
    By darkindesign in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: May 22nd, 12:14 PM
  2. can I show only unique values in a List?
    By Mark.P. in forum Macromedia Flash Data Integration
    Replies: 2
    Last Post: October 2nd, 12:57 PM
  3. can I show only unique values in a dataGrid?
    By Mark.P. in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: September 26th, 04:00 PM
  4. Query selecting unique values
    By RuBot in forum Macromedia ColdFusion
    Replies: 3
    Last Post: August 22nd, 05:52 PM
  5. get_meta_tags expects unique name values
    By Peter N. Schweitzer in forum PHP Development
    Replies: 0
    Last Post: October 30th, 09:37 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139