rows are repeating 2 times,how to avoid that

  • hi

    i am getting result like this

    1 product1 12.34 32.11

    1 product1 null null

    2 product2 15.00 15.35

    2 product2 null null

    i just want my result like this

    1 product1 12.34 32.11

    2 product2 15.00 15.35

    i tried to use distinct ,doesnt work.

    please help

  • How about using NOT NULL in a WHERE?

    _________________________________
    seth delconte
    http://sqlkeys.com

  • Unfortunately, without the source data or the query you are running there really isn't much more we can do to help.

    I suggest that you take the time to read the first article I reference below on "Asking for help." Following the instructions provided in that article regarding what and how you should post the information we need to help you and you will get better answers to your questions. In addition, you will also get tested code in return.

  • thanks so much , you save me today

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

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