SQL select statement Union question   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse TalkArchives - 2008Cine Talk - Reviews, Gossips, Insider Info etc.Archive through March 24, 2008 � SQL select statement Union question Previous Next

Author Message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Bignole
Mudiripoyina Bewarse
Username: Bignole

Post Number: 7868
Registered: 03-2004
Posted From: 161.225.1.12

Rating:N/A
Votes: 0(Vote!)

Posted on Thursday, March 13, 2008 - 4:19 pm:Edit PostDelete PostView Post/Check IP

dardrudu GC antene future employement kada. Ippudu pay cheyyakkarledhu. GC vachaka pay seyyali. House teesi EAD vadatannava? ee twistu endhi?
Lakshallo Okkadni ....Laksha mandhiki okkadini
Top of pagePrevious messageNext messageBottom of pageLink to this message

Pda
Celebrity Bewarse
Username: Pda

Post Number: 19654
Registered: 06-2006
Posted From: 75.173.47.119

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 10:24 pm:Edit PostDelete PostView Post/Check IP

//unionlo same table names kaadhu undaalsindhi,same column names and order...anduke oka dummy name ettesi cheyyamanna

you need same number of columns in both and those colums should be of same data types.. names okate undakkarledu ..it works by reference
Everything should be made as simple as possible, but no simpler.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Tingari_xx
Yavvanam Kaatesina Bewarse
Username: Tingari_xx

Post Number: 4405
Registered: 08-2006
Posted From: 76.109.180.176

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 10:21 pm:Edit PostDelete PostView Post/Check IP

avunaa, maa roomie frd ala seste accept seyaledu anta..so risk enduku ani anukunna beeresh
For everything , there is a first time and next time
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3558
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 10:09 pm:Edit PostDelete PostView Post/Check IP

tingari tammi :-)

ma friend okatanu apply chesadu. IELTS teesukomani adigadanta. kani tanu clear ga explain chesadanta. Education anta english lo vundi. us lo 7 yrs. nunchi vuntunnanu ani oka doucment la chesi pampadu. vadu accept chesadu.
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Tingari_xx
Yavvanam Kaatesina Bewarse
Username: Tingari_xx

Post Number: 4404
Registered: 08-2006
Posted From: 76.109.180.176

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 10:05 pm:Edit PostDelete PostView Post/Check IP

beer annai
my roomie took it, english education saripodu...english speaking country ayyundaali...married vallaki no need bcos u reached the points
For everything , there is a first time and next time
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3557
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 10:02 pm:Edit PostDelete PostView Post/Check IP

ielts raste manchide kani compulsory kadu. if your educations is in English you can justify it. you don;t need to take ielts exam.
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Tingari_xx
Yavvanam Kaatesina Bewarse
Username: Tingari_xx

Post Number: 4403
Registered: 08-2006
Posted From: 76.109.180.176

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 10:01 pm:Edit PostDelete PostView Post/Check IP

academic ielts kaadu appi baa, immigration purpose kosam inkoti vundi...manchi score ravali anukunta andulo
For everything , there is a first time and next time
Top of pagePrevious messageNext messageBottom of pageLink to this message

Aggi_pidugu
Celebrity Bewarse
Username: Aggi_pidugu

Post Number: 20662
Registered: 05-2006
Posted From: 24.239.45.239

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:59 pm:Edit PostDelete PostView Post/Check IP

ielts emundi dead easyyy
hasta la victoria siempre
Top of pagePrevious messageNext messageBottom of pageLink to this message

Tingari_xx
Yavvanam Kaatesina Bewarse
Username: Tingari_xx

Post Number: 4402
Registered: 08-2006
Posted From: 76.109.180.176

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:55 pm:Edit PostDelete PostView Post/Check IP

canada ki IELTS raayali
For everything , there is a first time and next time
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3556
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:55 pm:Edit PostDelete PostView Post/Check IP

masters vunte 24 points
4 yr. exp vunte 24 points.. 2 yrs. ki around 20 points
age < 40 aite 10 points
wife education ki min 20 points
english speaking 24 points


total 67 points vaste apply cheyyochhu. manam easy ga qualify avutamu.
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 14647
Registered: 01-2005
Posted From: 71.65.195.103

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:53 pm:Edit PostDelete PostView Post/Check IP

beeresh criteria enti.evalo sepparu naku US lo MS plus 2yrs paina work experience unte easy gane vostundi ata kada canada PR
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3555
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:52 pm:Edit PostDelete PostView Post/Check IP

Canada immigration chala easy. points based. only $2000 avutundi. maname apply chesukovachhu.
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 14646
Registered: 01-2005
Posted From: 71.65.195.103

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:50 pm:Edit PostDelete PostView Post/Check IP

bongulo aus ki evadu ehess apply sesedi bongulodi nuvvu seppataniki memu inataniki saripoyama appi baa
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 5085
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:48 pm:Edit PostDelete PostView Post/Check IP

Canadian PR ki maname apply cheskovachu anukunta
nenu legend ee baabu (dhramavaram style lo chadukondi)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3554
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:47 pm:Edit PostDelete PostView Post/Check IP

avunu hemu
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Aggi_pidugu
Celebrity Bewarse
Username: Aggi_pidugu

Post Number: 20661
Registered: 05-2006
Posted From: 24.239.45.239

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:47 pm:Edit PostDelete PostView Post/Check IP

costs u around 5k AU$ for everything
hasta la victoria siempre
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6192
Registered: 06-2004
Posted From: 24.181.242.161

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:46 pm:Edit PostDelete PostView Post/Check IP

amma denemma ila koda unda...time bad anthe
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3553
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:46 pm:Edit PostDelete PostView Post/Check IP

ok.. hari.. choostanu. entavutundi apply cheyyataniki.
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Aggi_pidugu
Celebrity Bewarse
Username: Aggi_pidugu

Post Number: 20660
Registered: 05-2006
Posted From: 24.239.45.239

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:40 pm:Edit PostDelete PostView Post/Check IP

beeresh oka sari chudu www.immi.gov.au

Alane akkada PR vaste kanuka E3 ani work visa istadu US ki u can work just like H1.

Chippesh AUS sports lone baga naatu otherwise they are really good ppl. Nenu AUS michina sporting country chudaledu ippati varuku
hasta la victoria siempre
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 5084
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:38 pm:Edit PostDelete PostView Post/Check IP

Asstralia sucks
nenu legend ee baabu (dhramavaram style lo chadukondi)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3552
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:38 pm:Edit PostDelete PostView Post/Check IP

Thanks Aggi tata. ippude immigration ki chala karchu chesa. inkemi option leka pote chalo
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Aggi_pidugu
Celebrity Bewarse
Username: Aggi_pidugu

Post Number: 20659
Registered: 05-2006
Posted From: 24.239.45.239

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:37 pm:Edit PostDelete PostView Post/Check IP

WTH??

WH T F???

Evado seppedi vinabaka chusaka cheppu
hasta la victoria siempre
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 5083
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:37 pm:Edit PostDelete PostView Post/Check IP

tokkalo Australia.. racist naa kos
nenu legend ee baabu (dhramavaram style lo chadukondi)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Aggi_pidugu
Celebrity Bewarse
Username: Aggi_pidugu

Post Number: 20658
Registered: 05-2006
Posted From: 24.239.45.239

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:35 pm:Edit PostDelete PostView Post/Check IP

Beeresh Canada vese mundu Australia oka sari alochinchu akkada market chala bagundi and u can get ur citizenship in 3yrs after going there.
$ also around 37rs
hasta la victoria siempre
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 5082
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:35 pm:Edit PostDelete PostView Post/Check IP

mee employer koncham refund cheyamanu adugu beeresh. Nenu konnappudu approve aythene full amt isthani bargain chesa
nenu legend ee baabu (dhramavaram style lo chadukondi)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 14645
Registered: 01-2005
Posted From: 71.65.195.103

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:34 pm:Edit PostDelete PostView Post/Check IP

orni anta set avuddi le beeresh.ee lekkana GC filing enta tvaragaa cheste anta manchidi emo
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3551
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:32 pm:Edit PostDelete PostView Post/Check IP

Thanks Chip :-)
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 5081
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:30 pm:Edit PostDelete PostView Post/Check IP

time di emundy le ok achance teeskunnav anthey but money ee bokka. Lets hope u'll make up this loss @ some other place.
nenu legend ee baabu (dhramavaram style lo chadukondi)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3550
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:28 pm:Edit PostDelete PostView Post/Check IP

ade kada ippudu badha anta. time waste+money waste

basically time bad
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 5080
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:26 pm:Edit PostDelete PostView Post/Check IP

ippudu apply cheshtey labor approve ayyi, h1 extensions file cheskovachhu anuko but actual GC raaniki enni yrs avuddo
nenu legend ee baabu (dhramavaram style lo chadukondi)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3549
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:19 pm:Edit PostDelete PostView Post/Check IP

ade avutundi. ma company lo chala mandiki approve ayyayi, kani nade teda chesidi chipesh. kakapote into 11/2 yr. vundi h1b lo. ma vadu malli apply chestanantunnadu. ee loga Canada immigration kooda apply chestunna.
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 5079
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:16 pm:Edit PostDelete PostView Post/Check IP

avunu Beeresh, 90k GC vachhaka ichhe pay anattu..kavlaney reject chesi nattunnaru
nenu legend ee baabu (dhramavaram style lo chadukondi)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3548
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 9:09 pm:Edit PostDelete PostView Post/Check IP

na daniki kooda query vesadu. reply chesaru. aina reject chesadu. qry entante eb2 kinda prevailing wage 90k pettaru. naku around 70K vundi ee year W-2 lo. oka 10K per diem istunnaru. company pay cheyyatam ledani reject chesadu. Actual ga ma vadini adigite, 90k green card vachhetappudu pay cheyyali. ippudu avasaram ledu kani ee madhya kavalani reject chestunnaru ani antunnadu.
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 5075
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:58 pm:Edit PostDelete PostView Post/Check IP


nenu legend ee baabu (dhramavaram style lo chadukondi)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Murugu
Pilla Bewarse
Username: Murugu

Post Number: 223
Registered: 10-2006
Posted From: 69.91.95.161

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:52 pm:Edit PostDelete PostView Post/Check IP

kodi_nbk === r brahmam..?


please..tell..no
maa badugu devudini ...dooshinchina mundal valli ..jeevithantham nasinchaali...
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6191
Registered: 06-2004
Posted From: 57.68.10.185

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:27 pm:Edit PostDelete PostView Post/Check IP

10K poyayi ga. mari lawyer fees etc untayemo ga...chass..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6190
Registered: 06-2004
Posted From: 57.68.10.185

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:27 pm:Edit PostDelete PostView Post/Check IP

orni nijama??? ala ela deny chesadehee sodi nayalu. naa 140 ki query vesadu chinnade...pamparu veellu. monne approve ayyindi.

emani reason cheppadu beeresh deny chesinanduku?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 51411
Registered: 07-2004
Posted From: 70.44.12.14

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:19 pm:Edit PostDelete PostView Post/Check IP

vorni....sorry to hear it beeresh
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3547
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:16 pm:Edit PostDelete PostView Post/Check IP

jevvitam lo kattalanni okesari vachhai

I-140 denied $10K spend on GC gone

Canda immigration trying
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 14643
Registered: 01-2005
Posted From: 71.65.195.103

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:15 pm:Edit PostDelete PostView Post/Check IP

vuncle vi saati vuncle kastalu ardam sesukokapothe etta gosi baa
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 51408
Registered: 07-2004
Posted From: 70.44.12.14

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:08 pm:Edit PostDelete PostView Post/Check IP

beeresh,enti botthigaa blackberry aiponaav

Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6189
Registered: 06-2004
Posted From: 57.68.10.185

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:06 pm:Edit PostDelete PostView Post/Check IP

beeresh..gochi ichindi work ayindi mari.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6188
Registered: 06-2004
Posted From: 57.68.10.185

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:06 pm:Edit PostDelete PostView Post/Check IP

ento ee madhya thega working sethunna ayina office nayallu happy ga leru. edavalu kummi padesthunnaru. prathokkadu maaku mundu kavali ante maaku mundu kavali anta. chi.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 14641
Registered: 01-2005
Posted From: 71.65.195.103

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:03 pm:Edit PostDelete PostView Post/Check IP

Ledu beeresh gochi icchindi correct '' work avuddi
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3546
Registered: 09-2006
Posted From: 71.10.224.2

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:02 pm:Edit PostDelete PostView Post/Check IP

select v.name, t.number
from vendors v, test t
where ..
group by
v.name,
t.number
Union
select v.name, '' number
from vendors v
where..
group by
v.name, number

.. kani '' space work avvademo. edina default number work avutundi (like

0 number )
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6187
Registered: 06-2004
Posted From: 57.68.10.185

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:02 pm:Edit PostDelete PostView Post/Check IP

gochi mama, it worked.

nenu rasindi koda almost work ayyindi kani nenu instead of ' ' badulu some junk value like anonymouse ani display chesa...

kummesav mama :-)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 51407
Registered: 07-2004
Posted From: 70.44.12.14

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:01 pm:Edit PostDelete PostView Post/Check IP

unionlo same table names kaadhu undaalsindhi,same column names and order...anduke oka dummy name ettesi cheyyamanna adhi lekapoina work avuthaandhigaa,enjoy maadio
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6186
Registered: 06-2004
Posted From: 57.68.10.185

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 8:01 pm:Edit PostDelete PostView Post/Check IP

gochi mama..nenu rasindi inka edo modify cheyyali...nuvvu raasindi try chesthunna aagu. nenu as it is ga ala cheyyaledu indaka...aagu sethanna run avuthundi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6185
Registered: 06-2004
Posted From: 57.68.10.185

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 7:58 pm:Edit PostDelete PostView Post/Check IP

gochi mama, ala isthe union lo same table names undali select lo ani error vachindi. anduke elagabha anukunna. final ga mixing chesa..work avuthundi inka. kiki.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6184
Registered: 06-2004
Posted From: 57.68.10.185

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 7:57 pm:Edit PostDelete PostView Post/Check IP

2nd select lo koda t table adding chesi v table loni oka junk value tho set chesa danni. work avuthundi inka.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 51406
Registered: 07-2004
Posted From: 70.44.12.14

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 7:56 pm:Edit PostDelete PostView Post/Check IP

select
v.name,
t.number "number"
from vendors v, test t
where ..
group by
v.name,
t.number

Union
select
v.name,
' ' "number"
from vendors v
where..
group by
v.name,
' '


idhi try cheyyi hemesh...gathamlo nenu ilaane chesaa chaala querieslo...it should work
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 14639
Registered: 01-2005
Posted From: 71.65.195.103

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 7:52 pm:Edit PostDelete PostView Post/Check IP


Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6183
Registered: 06-2004
Posted From: 57.68.10.185

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 12, 2008 - 7:40 pm:Edit PostDelete PostView Post/Check IP

nenu ipudu 2 quries union chesthunna..

select v.name, t.number
from vendors v, test t
where ..
group by
v.name,
t.number
Union
select v.name, ?
from vendors v
where..
group by
v.name
?

ippudu 2nd select lo t table ledu...ayina akkada oka dummy column value ichi rayocha union. ela rayali rasthe...2nd select lo t table vaadakodadu..kani 2nd select values and 1st select values join cheyyali.

inthaki nenu rase union correct ee naa