MS access sql query help help help

Posted by Ashpal under Others on 5/21/2014 | Points: 10 | Views : 588 | Status : [Member] | Replies : 4
Hi,
I have a table which looks like

a1 b1 c1 d1
b1 c1 d1 (a1 value is missing)
a2 b2 c2 d2
b2 c2 d2 ( a2 value is missing)
b3 c3 d2 (a3 value does not exists)
a4 b4 c4 d4

how can I query the table so the result table looks like

a1 b1 c1 d1
a2 b2 c2 d2
b3 c3 d3
a4 b4 c4 d4

Thanks in advance
AshPal




Responses

Posted by: Vuyiswamb on: 5/22/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
your explanation is not yet enough for someone to help you, try to explain better again

Thank you for posting at Dotnetfunda
[Administrator]

Ashpal, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ashpal on: 5/22/2014 [Member] Starter | Points: 25

Up
0
Down
hi

I have a table in which some rows are almost same but data in one column is not here.
As shown above first and second row are same but a1 value is missing in the column A of second row.
I donot want that row with less data. I canot delete row by row as there are so many rows.

Hope this explains it.

Thanks,
Ashpal

Ashpal, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 5/22/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
Where a where clause to exclude them where that field <> is the value you suspect it is in that field. "Null" or "Empty string"


Thank you for posting at Dotnetfunda
[Administrator]

Ashpal, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ashpal on: 5/26/2014 [Member] Starter | Points: 25

Up
0
Down

let me expalin more clearly,

First two rows:

There are two rows with identical data except with value(a1) missing in one colums. (First two rows in the example given. there is a1 value but it is missing in second row.)
In some rows the value is not available and no other row with identical data. ( Thirs row in the example. a3 value is not available.)

So I cannot filter with where clause because I want third in the table where a3 value is null



Ashpal, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response