SQL Queries Doubts

[nenuinthe]

[quote author=meghana9 link=topic=194499.msg2371184#msg2371184 date=1305832619]
  F@!n F@!n join the below two tables

a.  PWN401D18 50_[ACC].dbo.P_CE B_CDC_MBR S_3q10
b.  [CHCQES].[dbo].[t_membership_span_id] 

using column name [b]MEMBERID[/b]  and name the result table as [b]Beacon_CD C_MBRS[/b]

by doing this you are done with your 1st part :)
[/quote]asalu e part ayyinda....MEMBERID use chesi JOIN cheyyamanaru ante just INNER JOIN a...leka any other join a??

[katharnak]

[quote author=PMREDDY19 link=topic=194499.msg2371521#msg2371521 date=1305835802]
kathi baa ila maa NY vallani anadam memu oppukomu..

NY vallu Db lo andariki telusu...
[/quote]

fans aaa  F@!n F@!n F@!n asalu e east lo unnavallu.. undi vellinollu antha spammers enaa  ^G#W ^G#W

[manoghna]

[quote author=BEZAWADA ROWDY link=topic=194499.msg2371593#msg2371593 date=1305837361]
asalu e part ayyinda....MEMBERID use chesi JOIN cheyyamanaru ante just INNER JOIN a...leka any other join a??
[/quote] specify cheyaledhuga so default Inner join

[K.A.Paul]

[quote author=katharnak link=topic=194499.msg2371622#msg2371622 date=1305837717]
fans aaa  F@!n F@!n F@!n asalu e east lo unnavallu.. undi vellinollu antha spammers enaa  ^G#W ^G#W
[/quote] @gr33d nenu tappaaa  &D_@@

[nenuinthe]

[quote author=katharnak link=topic=194499.msg2371622#msg2371622 date=1305837717]
fans aaa  F@!n F@!n F@!n asalu e east lo unnavallu.. undi vellinollu antha spammers enaa  ^G#W ^G#W
[/quote] damn damn[quote author=meghana9 link=topic=194499.msg2371625#msg2371625 date=1305837746]
specify cheyaledhuga so default Inner join
[/quote]asalu ina e Database...poni rendu tables lo column enti...endukante a result set ni inko table lo pettamanaru...inko table create cheyyamanadu...daniki datatypes endi??

inka simple ga join statement rayali ante

select T1.Col1,T1.Col2,T1.MEMBERID from  ACC.dbo.P_CEB _CDC_MBRS T1
join  [CHCQES].[dbo].[t_membership_span_id] T2 on T1.MEMBERID = T2.MEMBERID

[K.A.Paul]

[quote author=meghana9 link=topic=194499.msg2371625#msg2371625 date=1305837746]
specify cheyaledhuga so default Inner join
[/quote]ne lo  entha talent vundaaaa  F@!n F@!n

[manoghna]

[quote author=BEZAWADA ROWDY link=topic=194499.msg2371653#msg2371653 date=1305838048]
damn damnasalu ina e Database...poni rendu tables lo column enti...endukante a result set ni inko table lo pettamanaru...inko table create cheyyamanadu...daniki datatypes endi??

inka simple ga join statement rayali ante

select T1.Col1,T1.Col2,T1.MEMBERID from  ACC.dbo.P_CEB _CDC_MBRS T1
join  [CHCQES].[dbo].[t_membership_span_id] T2 on T1.MEMBERID = T2.MEMBERID
[/quote] oh a result table lo vunna columns e two tables lo vuntai anamata... so manam a columns ni select chesi join chesi akada specify chesina name ivali a result table ki

[nenuinthe]

[quote author=meghana9 link=topic=194499.msg2371673#msg2371673 date=1305838217]
oh a result table lo vunna columns e two tables lo vuntai anamata... so manam a columns ni select chesi join chesi akada specify chesina name ivali a result table ki
[/quote]emo le li8 manodu ledu anukunta ga vaste chudachu le kanivu..ne marketing etta undi

[manoghna]

[quote author=BEZAWADA ROWDY link=topic=194499.msg2371682#msg2371682 date=1305838279]
emo le li8 manodu ledu anukunta ga vaste chudachu le kanivu..ne marketing etta undi
[/quote] but he done with that 2 parts in the requirement.. 3rd part ki help kavali anta....
recent ga job vachindhi

[Ranga_The_Donga]

[quote author=meghana9 link=topic=194499.msg2371673#msg2371673 date=1305838217]
oh a result table lo vunna columns e two tables lo vuntai anamata... so manam a columns ni select chesi join chesi akada specify chesina name ivali a result table ki
[/quote]

loolks like three part name...


synonym create seyala ah... sCo_^Y sCo_^Y sCo_^Y

[nenuinthe]

[quote author=meghana9 link=topic=194499.msg2371695#msg2371695 date=1305838367]
but he done with that 2 parts in the requirement.. 3rd part ki help kavali anta....
recent ga job vachindhi
[/quote]oh ok...i am late a ok...whats 3rd part

[PMREDDY19]

[quote author=katharnak link=topic=194499.msg2371622#msg2371622 date=1305837717]
fans aaa  F@!n F@!n F@!n asalu e east lo unnavallu.. undi vellinollu antha spammers enaa  ^G#W ^G#W
[/quote]
of course East Coast Rocks,..

e chicagolaa MAy lo kuda intha chali kalam antey maa valla kadhu baa...

[Bairagi From Bapatla]

[quote author=BEZAWADA ROWDY link=topic=194499.msg2371682#msg2371682 date=1305838279]
emo le li8 manodu ledu anukunta ga vaste chudachu le kanivu..ne marketing etta undi
[/quote]
1st dantlo member id use chesi join chesa baa... 2nd dantlo kuda aa criteria use chesi join chesa but 3rd req ki logic ela rasthe vachido ardham kaka chasthunna.....

[nenuinthe]

[quote author=Bairagi From Bapatla link=topic=194499.msg2371710#msg2371710 date=1305838518]
1st dantlo member id use chesi join chesa baa... 2nd dantlo kuda aa criteria use chesi join chesa but 3rd req ki logic ela rasthe vachido ardham kaka chasthunna.....
[/quote]Database endi Oracle or SQL Server or....

[Bairagi From Bapatla]

[quote author=BEZAWADA ROWDY link=topic=194499.msg2371745#msg2371745 date=1305838798]
Database endi Oracle or SQL Server or....
[/quote]

ila adagatam em bhagola baa... antha pedha board etti SQL queries ante nu malli db endi aduguthunav....

anyways SQL baaaaaa.....