Doubt

[laggaitthu]

oka SQL table lo

ZIP_CD,ZIP_STATE,ZIP_FRAUD ani 3 colmns unnayi

ippudu ZIP_CD lo unna zip code ni chusi chesi adhi correct zip ey na or fraud zip aa ani kanipettali ante manam iche zip em return chesthundho chudali..

correct zip ayithe ZIP_STATE lo unna state ravali

wrong ayithe ZIP_FRAUD lo unna F ani ravali...

dheeniki query ela raayali SQL?

help please

[laggaitthu]

help

[laggaitthu]

ltt help

[cherlapalli_jailer]

tbl structure tappu bro

[cherlapalli_jailer]

nee req artham ayyindi kaani nuvvu chaala tension/knagaru lo vunnavu

nothing to worry..it is very simple only thing is we need correct info anthe

[laggaitthu]

[quote name='cherlapalli_jailer' timestamp='1346351147' post='1302408755']
nee req artham ayyindi kaani nuvvu chaala tension/knagaru lo vunnavu

nothing to worry..it is very simple only thing is we need correct info anthe
[/quote]
three colmns unnayi mama payina mention chesinavi

ippudu oka zip code ichamanuko adhi correct zip code ayithe state name display cheyyali wrong name ayithe fraud F ani display cheyyali.. ila chydaaniki query kaavali anthe

[laggaitthu]

00210,"NH","F" 00211,"NH","F" 00212,"NH","F" 00213,"NH","F" 00214,"NH","F" 00215,"NH","F" 00501,"NY","F" 00544,"NY","F" 00601,"PR","F" 00602,"PR","F" 00603,"PR","F" 00604,"PR","F" 00605,"PR","F" 00606,"PR","F" 00610,"PR","F" 00611,"PR","F" 00612,"PR","F" 00613,"PR","F" 00614,"PR","F" 00616,"PR","F" 00617,"PR","F" 00622,"PR","F" 00623,"PR","F" 00624,"PR","F" 00627,"PR","F" 00631,"PR","F"

[laggaitthu]

adhe table structure ZIP_CD ZIP_STATE ZIP_FRAUD

[cherlapalli_jailer]

now it is clear give a min

[laggaitthu]

I'm counting on u please help me[quote name='cherlapalli_jailer' timestamp='1346351560' post='1302408832']
now it is clear give a min
[/quote]

[laggaitthu]

please

[laggaitthu]

ltt

[cherlapalli_jailer]

give 5 mins boss PM is around

[laggaitthu]

Ok

[cherlapalli_jailer]

select count(*) fromtbl where [color=#282828][font=helvetica, arial, sans-serif]ZIP_CD = '12345'[/font][/color]


[color=#282828][font=helvetica, arial, sans-serif]if(count>0) [/font][/color]
select [color=#282828][font=helvetica, arial, sans-serif],ZIP_STATE from tb[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]else[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]select 'F' [/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]let me fine tune it before u finally use[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]till then play around[/font][/color]