stewiegriffin Posted June 12, 2011 Report Posted June 12, 2011 [quote author=HAPPYNESS link=topic=201842.msg2463485#msg2463485 date=1307844311] sCo_^Y sCo_^Y sCo_^Y we are doing this to extract some missing data in table 1 by matching it with table 2? sCo_^Y sCo_^Y sCo_^Y [/quote]we r trying to join those two tables using a common column...u can put whatever column names u want after select..
king420 Posted June 12, 2011 Author Report Posted June 12, 2011 [quote author=stewiegriffin link=topic=201842.msg2463486#msg2463486 date=1307844517]we r trying to join those two tables using a common column...u can put whatever column names u want after select..[/quote]Table1 ID name salary1 Hangover 10002 Psychopk 9003 Patriot 11004 Idli 4000Table 2ID Name Salary hierarchy 1 HangOver 1000 Legend2 Happyness 100000 SR.Hero3 Patriot 1100 Legend4 PsychoPk 900 Legend5 Katharnak 1500 Legendee rendu tables ki Inner join cheste ....out put table emosthundi?? sCo_^Y sCo_^Y sCo_^Y sCo_^Y Outer Join cheste Output table emostundi sCo_^Y sCo_^Y sCo_^Y
chicago Posted June 12, 2011 Report Posted June 12, 2011 [quote author=HAPPYNESS link=topic=201842.msg2463256#msg2463256 date=1307839889] deeni meaning ento koncham explain cheyyi baa ee debba tho Joins neercheskunta..[/quote] @3$% @3$% @3$% ^G#W ^G#W cheppachu kadha pillalaki....
king420 Posted June 12, 2011 Author Report Posted June 12, 2011 [quote author=chicago link=topic=201842.msg2463494#msg2463494 date=1307844892] @3$% @3$% @3$% ^G#W ^G#W cheppachu kadha pillalaki....[/quote] s%H# s%H# s%H# s%H# s%H#
chicago Posted June 12, 2011 Report Posted June 12, 2011 [quote author=stewiegriffin link=topic=201842.msg2463254#msg2463254 date=1307839828]do we use 'IN' in joins..??? ON kadaselect * from Table1 left join Table2 on Table1 .product=Table2 .product[/quote]left join on table 2 where some thing undali anukunta
chicago Posted June 12, 2011 Report Posted June 12, 2011 [quote author=HAPPYNESS link=topic=201842.msg2463496#msg2463496 date=1307844940] s%H# s%H# s%H# s%H# s%H#[/quote]terradata joins dagara unna petayala e thread lo
king420 Posted June 12, 2011 Author Report Posted June 12, 2011 [quote author=chicago link=topic=201842.msg2463501#msg2463501 date=1307845040]terradata joins dagara unna petayala e thread lo[/quote] naaku queries raayadam raadu s%H# s%H# s%H# ETL packages Visio lo ayete develop chesta.... Queries manaki Beebbbeeee s%H# s%H# sSa_j@il sSa_j@il
chicago Posted June 12, 2011 Report Posted June 12, 2011 [quote author=HAPPYNESS link=topic=201842.msg2463504#msg2463504 date=1307845145] naaku queries raayadam raadu s%H# s%H# s%H# ETL packages Visio lo ayete develop chesta.... Queries manaki Beebbbeeee s%H# s%H# sSa_j@il sSa_j@il[/quote]ehe nenu adhi anatledhu...patriot anadu akadha nerchukundamu evening nai...andhuku joins topics e thread lo vesestha.....
C Nation Posted June 12, 2011 Report Posted June 12, 2011 [quote author=HAPPYNESS link=topic=201842.msg2463493#msg2463493 date=1307844850]Table1 ID name salary1 Hangover 10002 Psychopk 9003 Patriot 11004 Idli 4000Table 2ID Name Salary hierarchy 1 HangOver 1000 Legend2 Happyness 100000 SR.Hero3 Patriot 1100 Legend4 PsychoPk 900 Legend5 Katharnak 1500 Legendee rendu tables ki Inner join cheste ....out put table emosthundi?? sCo_^Y sCo_^Y sCo_^Y sCo_^Y Outer Join cheste Output table emostundi sCo_^Y sCo_^Y sCo_^Y[/quote]inner join resultsID name salary hierarchy 1 Hangover 1000 legend2 Psychopk 900 legend3 Patriot 1100 legendouter join resultsID name salary hierarchy 1 Hangover 1000 legend2 Psychopk 900 legend3 Patriot 1100 legend4 Idli 4000 NULL
chicago Posted June 12, 2011 Report Posted June 12, 2011 [quote author=chicago link=topic=201842.msg2463498#msg2463498 date=1307844979]left join on table 2 where some thing undali anukunta[/quote]tappu tappu ........u r correst.......... @3$% @3$% @3$% s%H#
C Nation Posted June 12, 2011 Report Posted June 12, 2011 [quote author=chicago link=topic=201842.msg2463498#msg2463498 date=1307844979]left join on table 2 where some thing undali anukunta[/quote]left outer join [color=red]ON [/color]ani rasadu gaaa.
chicago Posted June 12, 2011 Report Posted June 12, 2011 [quote author=C Nation link=topic=201842.msg2463551#msg2463551 date=1307847044]left outer join [color=red]ON [/color]ani rasadu gaaa.[/quote]my bad....... s%H#
king420 Posted June 12, 2011 Author Report Posted June 12, 2011 [quote author=C Nation link=topic=201842.msg2463549#msg2463549 date=1307846993]inner join resultsID name salary hierarchy 1 Hangover 1000 legend2 Psychopk 900 legend3 Patriot 1100 legendouter join resultsID name salary hierarchy 1 Hangover 1000 legend2 Psychopk 900 legend3 Patriot 1100 legend4 Idli 4000 NULL[/quote] thankyounaaku inko doubnt kuda undi baa... ippudu ee queries raasetappudua.table1.productID = b.table2.productID ani istaruuuaa "a" and "b" enduku???
C Nation Posted June 12, 2011 Report Posted June 12, 2011 [quote author=HAPPYNESS link=topic=201842.msg2463571#msg2463571 date=1307847416] thankyounaaku inko doubnt kuda undi baa... ippudu ee queries raasetappudua.table1.productID = b.table2.productID ani istaruuuaa "a" and "b" enduku???[/quote]a, b ani asalu ivvaru. may be select statement across different databases aithe use cheyyochu anukunta.a represents database1, b represents database2.
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts