Microsoft Access,SQL thelisina vallu unnara............Koncham urgent

[manoghna]

[quote author=ramu link=topic=151095.msg1763216#msg1763216 date=1296768244]
orei babu...kodhiga time pattina...clear ga nee base tables... neeku kavalasina result table (sample)/...nee question ikkada veyyi.... tvaraga pani ayidhi ... ila guess lu kotte pani taggidhi....result vachidhi....  sHa_fr1ends sHa_fr1ends
[/quote] @gr33d atleast screen shot vesina baguntadhi..

[nandamuribidda]

[quote author=ramu link=topic=151095.msg1763216#msg1763216 date=1296768244]
orei babu...kodhiga time pattina...clear ga nee base tables... neeku kavalasina result table (sample)/...nee question ikkada veyyi.... tvaraga pani ayidhi ... ila guess lu kotte pani taggidhi....result vachidhi....  sHa_fr1ends sHa_fr1ends
[/quote]

agreed agreed btw nee old username enti????????

[ramu]

[quote author=manoghna link=topic=151095.msg1763226#msg1763226 date=1296768345]
@gr33d atleast screen shot vesina baguntadhi..
[/quote] screen shot daaka avasarla kani.... base tables columns...required output columns n question.... ivi clear cheyyi....  sHa_high5ing sHa_high5ing

[vaasu]

orey ayya. neekosam kasepu brain use chesi previous page 2 queries ki answers petta. koncham choosi avi neeku use avuthayo ledho cheppara.

nuvvu ila choosi choodanattu unde chiraku thenguthundi. help cheyyabudhi kooda kaadu

[vaasu]

[quote author=manoghna link=topic=151095.msg1763208#msg1763208 date=1296768161]
ho ok kani inka doudts vasthunnai can i ask you and clarify my doudt  sSc_hiding2
[/quote]
adagochu. i can try to clarify. basic nenu sql side kaadhu. kaani edo koncham knowledge undhi. high level questions adigithe naa valla kaadhu.  sSa_j@il

[ramu]

[quote author=nandamuribidda link=topic=151095.msg1763240#msg1763240 date=1296768438]
agreed agreed btw nee old username enti????????
[/quote] old aa.....vunna okka id ni open cheyadanike time vundi savatla ee madhya....malli multi talent kuda na....  sAng_banghead2  sHa_high5ing sHa_high5ing

[manoghna]

[quote author=ramu link=topic=151095.msg1763252#msg1763252 date=1296768518]
  screen shot daaka avasarla kani.... base tables columns...required output columns n question.... ivi clear cheyyi....  sHa_high5ing sHa_high5ing
[/quote]chala columns vunte thanaki post cheyatam kastam ani ala annanu  sHa_high5ing

[Rising star]

[quote author=manoghna link=topic=151095.msg1763278#msg1763278 date=1296768670]
chala columns vunte thanaki post cheyatam kastam ani ala annanu  sHa_high5ing
[/quote] sHa_fr1ends sHa_fr1ends sHa_high5ing sHa_high5ing

[ramu]

[quote author=manoghna link=topic=151095.msg1763278#msg1763278 date=1296768670]
chala columns vunte thanaki post cheyatam kastam ani ala annanu  sHa_high5ing
[/quote] motham avasarla.... ee columns use cheyyalo idea vuntadhi ga question ki related ga....avi varaku...just table madhya relation (foreign key)details telustai ani...  sHa_high5ing sHa_high5ing

[manoghna]

[quote author=Alexander link=topic=151095.msg1763150#msg1763150 date=1296767693]
if a primary key is attached to 2 columns say column1, column2

column1 column2
1            1
1              2
1              3


the above rows can be inserted into table.
[color=red]if 2 columns are attached to primary key, then it will allow duplicate values for one column[/color]
[/quote]duplicate values vunapudu a column ki manam daniki primary key create chesi use enti...adhe duplicates values leni column create chesthe by using that we can get the details of the entire row kadha...i was into sql it might me helpful andhuke aduguthunanu sSa_j@il

[graham]

[quote author=Alexander link=topic=151095.msg1763259#msg1763259 date=1296768567]
orey ayya. neekosam kasepu brain use chesi previous page 2 queries ki answers petta. koncham choosi avi neeku use avuthayo ledho cheppara.

nuvvu ila choosi choodanattu unde chiraku thenguthundi. help cheyyabudhi kooda kaadu
[/quote]

@3$%  @gr33d kani papam edo panilo unduntaadu le  sHa_fr1ends you rock

[quote author=manoghna link=topic=151095.msg1763278#msg1763278 date=1296768670]
chala columns vunte thanaki post cheyatam kastam ani ala annanu  sHa_high5ing
[/quote]

[img]http://lh6.ggpht.com/_vGgr3WUJEdg/THehhVeF4rI/AAAAAAAADw4/q2Dy76xWF8A/Bemmiii (16).gif[/img]

[manoghna]

[quote author=ramu link=topic=151095.msg1763302#msg1763302 date=1296768897]
motham avasarla.... ee columns use cheyyalo idea vuntadhi ga question ki related ga....avi varaku...just table madhya relation (foreign key)details telustai ani...  sHa_high5ing sHa_high5ing
[/quote]ok  sHa_high5ing

[Rising star]

[quote author=MICKEY link=topic=151095.msg1763322#msg1763322 date=1296769125]
[img]http://lh6.ggpht.com/_vGgr3WUJEdg/THehhVeF4rI/AAAAAAAADw4/q2Dy76xWF8A/Bemmiii (16).gif[/img]
[/quote] Dr@w@ Dr@w@ Dr@w@ Dr@w@

[graham]

[quote author=Rising star link=topic=151095.msg1763330#msg1763330 date=1296769192]
Dr@w@ Dr@w@ Dr@w@ Dr@w@
[/quote]

edo chaduvukunnollu matladukuntunnaru manakem pani ikkada ; pada pada  @3$% @3$%

[Rising star]

[quote author=MICKEY link=topic=151095.msg1763338#msg1763338 date=1296769264]
edo chaduvukunnollu matladukuntunnaru manakem pani ikkada ; pada pada  @3$% @3$%
[/quote]gatlane... help seddam ani unna... kaani table structure telikunda emi seyyagalamu... question easy ne, but answer ee kashtam  sCh_elmodance2 sCh_elmodance2