Doubt

[laggaitthu]

hey now I got two tables in my data base one as SCR_ZIPS which contains all valid zips of USPS and other is DD_ZIPS which contains my company provided ZIPS in it

now my task is to see whether I have all the valid zips in DD_zips table comparing it to the SRC_ZIPS

so please help with a query to do it

[laggaitthu]

hey guys can use just JOIN to compare the ZIP codes of two tables

[Cherry25]

[quote name='laggaitthu' timestamp='1346359521' post='1302409997']
import chesa
[/quote]


You da man..Ivvaltiki chaalu ani vellipo bhayyaa...prepare ayyi vachi repu kummey..

[Cherry25]

[quote name='laggaitthu' timestamp='1346359677' post='1302410018']
hey now I got two tables in my data base one as SCR_ZIPS which contains all valid zips of USPS and other is DD_ZIPS which contains my company provided ZIPS in it

now my task is to see whether I have all the valid zips in DD_zips table comparing it to the SRC_ZIPS

so please help with a query to do it
[/quote]


Comparision antee...just kotta table lo unna zips existing table lo unnayya ani check cheyyala??? deeniki we can use set operators..

[laggaitthu]

[quote name='Cherry25' timestamp='1346360274' post='1302410105']


You da man..Ivvaltiki chaalu ani vellipo bhayyaa...prepare ayyi vachi repu kummey..
[/quote]
no ba idhi 1st task mottha chesesi eltha frasantham ga fadkovochu night ki

[laggaitthu]

SRC_ZIPS
1.)ZIP_CD
2.)ZIP_ST

DD_ZIPS
1.)ZIP_CD
2.)ZIP_STATE
3.)ZIP_FRAUD

so ee 2 tables meedha outer join use chesi 2 tables lo unna zips ni oput ga theppinhcaali

[laggaitthu]

ltt help pls

[Cherry25]

[quote name='laggaitthu' timestamp='1346360843' post='1302410173']
SRC_ZIPS
1.)ZIP_CD
2.)ZIP_ST

DD_ZIPS
1.)ZIP_CD
2.)ZIP_STATE
3.)ZIP_FRAUD

so ee 2 tables meedha outer join use chesi 2 tables lo unna zips ni oput ga theppinhcaali
[/quote]


nee purpose telidu kani,, nuvvu adigina danni batti try this
select distinct s.zip_cd,d.zip_cd from src s full outer join ddzips d on s.zip_cd=d.zip_cd;

[laggaitthu]

[quote name='Cherry25' timestamp='1346361555' post='1302410241']
nee purpose telidu kani,, nuvvu adigina danni batti try this
select distinct s.zip_cd,d.zip_cd from src s full outer join ddzips d on s.zip_cd=d.zip_cd;
[/quote]
no mama not working

[laggaitthu]

[quote name='Cherry25' timestamp='1346361555' post='1302410241']
nee purpose telidu kani,, nuvvu adigina danni batti try this
select distinct s.zip_cd,d.zip_cd from src s full outer join ddzips d on s.zip_cd=d.zip_cd;
[/quote]
purpose entante ee 2 tables lo unna
1.)ZIP_CD
2.)ZIP_CD

output table ila ravaali

[Cherry25]

[quote name='laggaitthu' timestamp='1346362687' post='1302410334']
no mama not working
[/quote]

aa query work avtadi oracle lo...dont copy paste...nenu table/column names correct ga ivvale

[laggaitthu]

k

[laggaitthu]

[quote name='Cherry25' timestamp='1346362860' post='1302410355']

aa query work avtadi oracle lo...dont copy paste...nenu table/column names correct ga ivvale
[/quote]
change chese icha mama avvatle

[Cherry25]

[quote name='laggaitthu' timestamp='1346363330' post='1302410399']
change chese icha mama avvatle
[/quote]


What error are u getting???

[Cherry25]

[quote name='laggaitthu' timestamp='1346363330' post='1302410399']
change chese icha mama avvatle
[/quote]


r both the tables in the same schema???