March 29, 2012 at 10:20 am
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
March 29, 2012 at 10:32 am
How about using NOT NULL in a WHERE?
_________________________________
seth delconte
http://sqlkeys.com
March 29, 2012 at 11:05 am
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.
March 29, 2012 at 11:26 am
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