Question

SELECT GDSBarnd, GDSSubBrand, GDSVariant, Description FROM Sheet1
WHERE Sheet1.GDSBarnd Is Null
OR Sheet1.GDSSubBrand Is Null
OR Sheet1.GDSVariant Is Null
OR Sheet1.Description Is Null

In the above query i have to find the null values in the fields of the table but query result to print the all values of the field.

But i have to print the particular column of the null values of the field...

Please give me a suggestion...

and i am also searching for this one.
If i found this answer i will put it on this page..

Answer 1

I'm not sure what you mean. Can you give us some sample output?

Answer 2

GDSBarnd GDSSubBrand GDSVariant Description
LIPTON BLACK S&T 1X1000 BAGS
LIPTON BLACK S&T 24X100 BAGS
LIPTON BLACK S&T 24X50 BAGS
PADDLE POP CHOCOLATE 32x70ml
BUSHELLS BL S&T TBLU 9x(100x1.8g)
BUSHELLS BL S&T TBLU 3X(276X1.8g)
BUSHELLS BL S&T TBL 12x(50x1.8g)
LANCHOO TB P-ENV VT 1X925g
LANCHOO TEA BAG SQ VT 1X1.85kg
LANCHOO TEA BAG S&T 1X1.85kg
CON CIB LEMON CHKN 2x10x52G
CON CIB PORT CHKN 2x10x45G
CON CIB HON BBQ CHKN 2x10x52G
CON CIB SM BBQ CHKN 2x10x52G
REXONA WMN SPRAY SKINLIGHT 8X6X150ml
BEN&JERRY N YORK SUP FUDGE AMET 8X458ML
IMPULSE DEO SPRAY ROMANTIC SPARK12X6X75G
AXE DARK TEMPTATION B.SPR.ETK 24X50 ML
PR MKT FS COOKING CAP P100
REXONA MEN RO ALL BLACK 48x50ML
SPLICE FRUIT ICE ORANGE 30x60mL (65g)
SPLICE FRUIT ICE KIWI 30x60mL (65g)
SPLICE FRUIT ICE STRAW 30x60ml (65g)
REXONA MEN AP DEO V8 8X6X150G
LUX SOAP WHITE ANZ 12X(4X100g)

Answer 3

this is the out put i got
when i run the above query.

Answer 4

Yes I got it answer

Answer 5

The Answer is
SELECT * FROM Sheet1 WHERE GDSBrand Is Null OR GDSVariant Is Null OR GDSSubBr
and IS Null;

Answer 6

Nice :)

As a side note, please don't use the report abuse button to communicate with us ;) Just post a reply, we'll get the message :)

Answer 7

sorry for the interrupt to send report message.
Any way Thanks for your suggestion...........

Answer 8

In Other way to find answer for the above query.
i.e. SELECT * FROM Sheet1
WHERE GDSBrand + GDSSubBrand + GDSVaraint Is Null

Answer 9

i got the another query for the given question.
the query is
SELECT Sheet1.[GDS Brand], Sheet1.[Brand = Funct Nam], Sheet1.[GDS Variant]
FROM Sheet1
WHERE (Sheet1.[GDS Brand]) Is Null OR (Sheet1.[Brand = Funct Nam]) Is Null OR (Sheet1.[GDS Variant]) Is Null;