| Author |
Message |
    
420
Kurra Bewarse
Username: 420
Post Number: 2267
Registered: 12-2006
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 3:14 pm: |    |
Gwochiee  |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 44706
Registered: 07-2004
Posted From: 162.136.192.1
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 3:13 pm: | |
penkesh 
Donate Blood Save Life ! Donate Eyes Live Twice  |
420
Kurra Bewarse
Username: 420
Post Number: 2265
Registered: 12-2006
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:44 pm: | |
 |
Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king
Post Number: 802
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:42 pm: | |
thank you 420 mama its working.... |
Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king
Post Number: 801
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:38 pm: | |
avunu hemanth |
420
Kurra Bewarse
Username: 420
Post Number: 2264
Registered: 12-2006
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:37 pm: | |
select p.date_detected,p.decision_number,d.client_id,d.fi rst_name||' '||d.middle_initial||' '||d.last_name,p.employer_no,t.emp_employer_name from
kkidder.person_details_issues p,kkidder.person_details d,
(select distinct substr(to_char(.emp_employ er_acct_no),1,length(to_char(t.emp_employer_acct_n o))-1) as employer_no from tax_master ) t
where
p.date_detected<(sysdate-200) and
p.status_code in (0,1) and
p.ssn=d.ssn and
to_char(p.employer_no)= t.employer_no |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 3862
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:34 pm: | |
ante ex: p.employer_no = 123 unte
t.employer_acct_no = 123 unna rows multiple unnaya? |
Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king
Post Number: 799
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:30 pm: | |
oracle reports lo mama adi...distinct antee tesukovadam ledu adi |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 44701
Registered: 07-2004
Posted From: 162.136.192.1
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:29 pm: | |
paina distinct petti choosaava symbol maama...
select distinct p.----
Donate Blood Save Life ! Donate Eyes Live Twice |
420
Kurra Bewarse
Username: 420
Post Number: 2263
Registered: 12-2006
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:28 pm: | |
 |
Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king
Post Number: 798
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:28 pm: | |
eppudu problem enti antee..
to_char(p.employer_no)=substr(to_char(t.emp_employ er_acct_no),1,length(to_char(t.emp_employer_acct_n o))-1)
ee comparision multiple rows ni return chestundi..table t loo emp_employer_acct_no unique kadu..so over all gaa query same data mutliple times chuspistondi |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 44700
Registered: 07-2004
Posted From: 162.136.192.1
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:28 pm: | |
emayyindi aa queryki 
Donate Blood Save Life ! Donate Eyes Live Twice |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 3861
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:27 pm: | |
ok next... |
Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king
Post Number: 796
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, August 14, 2007 - 2:26 pm: | |
select p.date_detected,p.decision_number,d.client_id,d.fi rst_name||' '||d.middle_initial||' '||d.last_name,p.employer_no,t.emp_employer_name from
kkidder.person_details_issues p,kkidder.person_details d,tax_master t where
p.date_detected<(sysdate-200) and
p.status_code in (0,1) and
p.ssn=d.ssn and
to_char(p.employer_no)=substr(to_char(t.emp_employ er_acct_no),1,length(to_char(t.emp_employer_acct_n o))-1)
edi naaa query |
