| Author |
Message |
    
Pakodi
Bewarse ke Bewarse!
Username: Pakodi
Post Number: 19785
Registered: 12-2004
Posted From: 130.15.147.81
| | Posted on Tuesday, August 08, 2006 - 1:42 pm: |    |
alaga cool mama |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1993
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Tuesday, August 08, 2006 - 1:40 pm: | |
yes mamma .. we are a huge gang in NL there are about 80 Kannada families in NL .. But I am a cat on the wall I can jump both ways .. |
Pakodi
Bewarse ke Bewarse!
Username: Pakodi
Post Number: 19784
Registered: 12-2004
Posted From: 130.15.147.81
| | Posted on Tuesday, August 08, 2006 - 1:37 pm: | |
ayyo hall pull aina bokka ante kashtam ga, planning lopama
anyway all the best this time. kannada vallu bagane unnara enti akkada. |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1992
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Tuesday, August 08, 2006 - 1:37 pm: | |
yes Mamma .. Toronto is cheap and nice .. I like Gerard Street .. full of our Restaurants .. |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1991
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Tuesday, August 08, 2006 - 1:36 pm: | |
NL = Netherlands ..
kikiki LNS thoooo exhibiting start sesaaaa ..
Hall was full , but still had couple hundreds of EUROS Bokkaaa . |
Pakodi
Bewarse ke Bewarse!
Username: Pakodi
Post Number: 19783
Registered: 12-2004
Posted From: 130.15.147.81
| | Posted on Tuesday, August 08, 2006 - 1:34 pm: | |
Nenu kingston mama prasthutham toronto ki 2.30 hrs. kani appudappudu work medha toronto lo untanu anuko
1yr tharavatha complete shipting aipotha ooru baguntadi. |
Pakodi
Bewarse ke Bewarse!
Username: Pakodi
Post Number: 19782
Registered: 12-2004
Posted From: 130.15.147.81
| | Posted on Tuesday, August 08, 2006 - 1:33 pm: | |
NL ante enti mama
cool mama nuvvu kuda exhibitor range ki edigav anamata |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1990
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Tuesday, August 08, 2006 - 1:32 pm: | |
PAKODI mamma .. are you in TORONTO , great .. i visit Toronto 3 times a year .. my elder brother is settled in Toronto ..
|
Pakodi
Bewarse ke Bewarse!
Username: Pakodi
Post Number: 19781
Registered: 12-2004
Posted From: 130.15.147.81
| | Posted on Tuesday, August 08, 2006 - 1:31 pm: | |
ledhu
toronto lo undhi ani theldhu |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1989
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Tuesday, August 08, 2006 - 1:30 pm: | |
PAKODI maaamaaa .. I am fine mamma ..
i am busy try to get POKIRI for Telugu Audience and JOGI for Kannada audience here in NL ...
how about u |
Rratna
Vooriki Bewarse
Username: Rratna
Post Number: 3127
Registered: 03-2004
Posted From: 24.172.181.205
| | Posted on Tuesday, August 08, 2006 - 1:29 pm: | |
pakodi Ashok choosava? |
Pakodi
Bewarse ke Bewarse!
Username: Pakodi
Post Number: 19780
Registered: 12-2004
Posted From: 130.15.147.81
| | Posted on Tuesday, August 08, 2006 - 1:27 pm: | |
pt etta undav |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1987
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Tuesday, August 08, 2006 - 1:23 pm: | |
by the way .. the query i gave works only for 9i and above |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1986
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Tuesday, August 08, 2006 - 1:22 pm: | |
by looking at your query , I think this is what you are looking for .. etteee ..
if not .. give me a detailed Spec with data for what u are looking for SEMPETHAAAA |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1985
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Tuesday, August 08, 2006 - 1:20 pm: | |
SELECT
Month ,
Sp_id
FROM
(select Month,
sp_id,
metric1 from table1 FULL OUTER JOIN table2 USING(Month) Temp1 FULL OUTER JOIN table3 USING (MONTH)) |
Etakaram
Pilla Bewarse
Username: Etakaram
Post Number: 242
Registered: 07-2005
Posted From: 162.136.192.1
| | Posted on Tuesday, August 08, 2006 - 1:16 pm: | |
 thanx maama...vacchindhaa ante ledhu..alaagane 3 unions use chesi query pampinchesaa vaallaki...sooddam performance emanna bagalekapothe get back avuthaaru..manam sesedhi eti ledhu...AW maama,aagu try chesthaa nuvvu seppindhi |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1984
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Tuesday, August 08, 2006 - 1:14 pm: | |
GOCHI mamma .. vachindaa Ledaa seppu .. or do u still need any help  |
Andhrawala
Desanike Pedda Bewarse
Username: Andhrawala
Post Number: 9579
Registered: 03-2004
Posted From: 192.58.204.226
| | Posted on Tuesday, August 08, 2006 - 12:49 pm: | |
//and aa.Month = cc.Month(+)
etakaaram then try otherway
and cc.Month = aa.Month(+)
try to dupe it |
Etakaram
Pilla Bewarse
Username: Etakaram
Post Number: 238
Registered: 07-2005
Posted From: 162.136.192.1
| | Posted on Tuesday, August 08, 2006 - 12:17 pm: | |
maradhi etta sesaavo seppochugandhaa  |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1983
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Tuesday, August 08, 2006 - 12:15 pm: | |
endukantee .. i remember pacing the same problem long long a ago .. .. i think i used an union trick and also full outer join syntax in the query |
Etakaram
Pilla Bewarse
Username: Etakaram
Post Number: 237
Registered: 07-2005
Posted From: 162.136.192.1
| | Posted on Tuesday, August 08, 2006 - 12:07 pm: | |
 deniki dancings PT maama.. |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1982
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Tuesday, August 08, 2006 - 12:05 pm: | |
 |
Etakaram
Pilla Bewarse
Username: Etakaram
Post Number: 230
Registered: 07-2005
Posted From: 162.136.192.1
| | Posted on Tuesday, August 08, 2006 - 11:55 am: | |
maama..alaa pedithe
"ORA-01417 : a table may be outer joined to at most one other table"
ani error vasthaandhi |
Andhrawala
Desanike Pedda Bewarse
Username: Andhrawala
Post Number: 9577
Registered: 03-2004
Posted From: 192.58.204.226
| | Posted on Tuesday, August 08, 2006 - 11:50 am: | |
what about if we add
select aa.Month,
aa.Sp_id,
nvl(aa.metric1,0)+nvl(bb.metric2,0)+nvl(cc.metric3 ,0) TOTAL
from
(select Month,sp_id,metric1 from table1)aa,
(select Month,sp_id,metric2 from table2) bb,
(select Month,sp_id,metric3 from table3) cc
where aa.Month = bb.Month(+)
and aa.Month = cc.Month(+)
and bb.Month = cc.Month(+) |
Etakaram
Pilla Bewarse
Username: Etakaram
Post Number: 228
Registered: 07-2005
Posted From: 162.136.192.1
| | Posted on Tuesday, August 08, 2006 - 11:44 am: | |
full outer join etta seyyalo evalikanna thelusaaa....
naa kaada 3 subqueries unnayi...aaa 3 queries ki oka daanitho inkokati full join seyyali..
select aa.Month,
aa.Sp_id,
nvl(aa.metric1,0)+nvl(bb.metric2,0)+nvl(cc.metric3 ,0) TOTAL
from
(select Month,sp_id,metric1 from table1)aa,
(select Month,sp_id,metric2 from table2) bb,
(select Month,sp_id,metric3 from table3) cc
where aa.Month = bb.Month(+)
and aa.Month = cc.Month(+)
ilaa raasthey just 'aa' lo undi 'bb' lo lenivi,'aa' lo undi 'cc' lo lenivi vasthaayi...kaani naaku eeee 3 subquerieslo ekkadunna aaa Month,Sp_id,Metric pick cheyyaali...
Just 2 subqueries unte union seyyocchu ani ekkado sadivaa....like
select xxxx
from xxxx
where aa = bb(+)
union
select xxxx
from xxxx
where bb = aa(+)
kaani ippudu 3 unte total 6 query combinations avuthaayi  inthakanna verey maargam edhanna undhaa  |
