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

[D9]

endo ee basha.... sSa_j@il sSa_j@il sSa_j@il

[iamme]

3 tables in data base
Details table lo student personal details anni untay....(Which has PIDMS as Primary key)
SHRD table lo student schooling info untundi.....          ( ee table lo Primary keys aemo PIDMS and SBGI code)
SBGI table lo thana previous schooll info untundi....    (Which has SBGI code as Primary key)
SBGI CODE anedi School code

SO ippudu naku NY state lo Previous schooling chesina students list kavali ante.....I need to have Details table......ok....aadetails table ni i cant directly link to SBGI table......Coz andulo PIDM ledu  ...So wat i did was ....SHRD table lo  kavalsina 2 primry keys unnay kada ani....Details table ni SHRD table ki link chesi akkada nunchi SBGI table ki link chesa...

Say suppose....
this is how My table looks like after i runt he query...

PIDM    SBGI_ID          AGE    School    School_STATE_CODE
1            23                    ------------------      CO
2            34                    -------------              NY
2            65                ---------------              NY
3            43              ---------------------        MN
4            67                ----------------              CT

Which means OKa student number 2 ......1st oka school lo join ayyadu Which is in NY....AAtharvatha NY lo ne inko school ki transfer ayyadu....

Ippudu nenu NY lo PREV schooling chesin valla list thesthunte...EE number 2 .......two times vasthunnadu...Coz of DIff School....

So Ippudu naku em kavalante......I wan Only Unique values of PIDMS i dnt care abt SBGI_ID. SELECT UNIQUE try chesa...but dint wrk....
This is my 1st prblm

Prblm 2) database table lo ila store chesi undi

PIDM    SBGI_ID          AGE    School    School_STATE_CODE
1            23                    ------------------      CO
2            34                    -------------              NY
2            65                ---------------              MN

Which means....Student Number 2.......!st NY lo school lo join ayyaka.....MN lo school ki transfer ayyadu...
So naku NY query lonu....vasthunnadu.....MN query lonu.... vasthunnadu..........

clear ga cheppataniki chala try chesa....

[iamme]

[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]

Na office aipoyindi...repu velli prayogistha....

[iamme]

Kavalani Late replies em ivvatledu...Koncham Busy ga undi ikkada.........Ny how...Ippudu question ardam ayyinda????LEda???????


Poni question ne inkela chepthe meeku clr ga ardam avthundo cheppandi..Ill try........

[vaasu]

[quote author=manoghna link=topic=151095.msg1763321#msg1763321 date=1296769114]
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
[/quote]
primary key anedhi okka column key untadhi ani nuvvu mental ga fix ayyavu. primary key lo more than one column undochu.

okka example :
user ane table lo firstname, lastname, phonenumber ani 3 columns unnayi anuko.
US lo same first name unnavallu lakshallo untaru. same last name unnavallu kooda anthe.
same firstname, lastname unnavallu kooda untaru. kaani same firstname, lastname, phonenum unnavallu undaru.
so ee table lo primary key ni 3 columns ki (firstname,lastname,phonenumber) ki attach chestharu.

primary key select statement lo chaala helpfull avuthundi. results fast gaa radaniki.
ilanti case lo nuvvu 4th column create chesi daanini primary key declare cheyyadam vallu use undadhu kada.

[manoghna]

[quote author=iamme link=topic=151095.msg1763374#msg1763374 date=1296769631]
Na office aipoyindi...repu velli prayogistha....
[/quote]ye join use chesaru a tables ki ?

[vaasu]

[quote author=iamme link=topic=151095.msg1763374#msg1763374 date=1296769631]
Na office aipoyindi...repu velli prayogistha....
[/quote]all the best. if i understood the question correctly, then they should work.  sHa_high5ing sHa_high5ing

[htnamus]

[quote author=Alexander link=topic=151095.msg1762996#msg1762996 date=1296766218]
second query ki answer

=ny ni alane unchu
<>ny ni koncham marchu

where School_STATE_CODE<>ny and PIDM not in (select PIDM from tablename where School_STATE_CODE='ny')
[/quote]chinna doubt ..nested queries kante joins vadatam efficient kada

[Rising star]

[quote author=HS link=topic=151095.msg1763414#msg1763414 date=1296770014]
chinna doubt ..nested queries kante joins vadatam efficient kada
[/quote]high school mama edhi seppithe adhi correct anthe... topic is over

[iamme]

[quote author=Alexander link=topic=151095.msg1763401#msg1763401 date=1296769924]
primary key anedhi okka column key untadhi ani nuvvu mental ga fix ayyavu. primary key lo more than one column undochu.

okka example :
user ane table lo firstname, lastname, phonenumber ani 3 columns unnayi anuko.
US lo same first name unnavallu lakshallo untaru. same last name unnavallu kooda anthe.
same firstname, lastname unnavallu kooda untaru. kaani same firstname, lastname, phonenum unnavallu undaru.
so ee table lo primary key ni 3 columns ki (firstname,lastname,phonenumber) ki attach chestharu.

primary key select statement lo chaala helpfull avuthundi. results fast gaa radaniki.
ilanti case lo nuvvu 4th column create chesi daanini primary key declare cheyyadam vallu use undadhu kada.
[/quote]

ayyo rama chandra...Oka column ke untundani fix ayi unntaythe.....SHRD table lo 2 primary keys unnayani y cheppanu???

[htnamus]

[quote author=Rising star link=topic=151095.msg1763428#msg1763428 date=1296770113]
high school mama edhi seppithe adhi correct anthe... topic is over
[/quote]okapudu chesa ba sql ..so doubt ante ..clarify cheskundamani

[manoghna]

[quote author=Alexander link=topic=151095.msg1763401#msg1763401 date=1296769924]
primary key anedhi okka column key untadhi ani nuvvu mental ga fix ayyavu. primary key lo more than one column undochu.

okka example :
user ane table lo firstname, lastname, phonenumber ani 3 columns unnayi anuko.
US lo same first name unnavallu lakshallo untaru. same last name unnavallu kooda anthe.
same firstname, lastname unnavallu kooda untaru. kaani same firstname, lastname, phonenum unnavallu undaru.
so ee table lo primary key ni 3 columns ki (firstname,lastname,phonenumber) ki attach chestharu.

primary key select statement lo chaala helpfull avuthundi. results fast gaa radaniki.
ilanti case lo nuvvu 4th column create chesi daanini primary key declare cheyyadam vallu use undadhu kada.
[/quote] sHa_clap4  sHa_clap4 thanks for ur patience and clarifying my question i didnt know this till now.... you rock  you rock

[vaasu]

[quote author=iamme link=topic=151095.msg1763432#msg1763432 date=1296770152]
ayyo rama chandra...Oka column ke untundani fix ayi unntaythe.....SHRD table lo 2 primary keys unnayani y cheppanu???
[/quote] @3$% @3$%
nenu evariki reply ichano okkasari choodu.  *7*^ *7*^

[manoghna]

[quote author=HS link=topic=151095.msg1763414#msg1763414 date=1296770014]
chinna doubt ..nested queries kante joins vadatam efficient kada
[/quote]s performance wise using joins are far better than using nested quiries...100% true... sHa_high5ing

[ramu]

[quote author=iamme link=topic=151095.msg1763365#msg1763365 date=1296769566]
3 tables in data base
Details table lo student personal details anni untay....(Which has PIDMS as Primary key)
SHRD table lo student schooling info untundi.....          ( ee table lo Primary keys aemo PIDMS and SBGI code)
SBGI table lo thana previous schooll info untundi....    (Which has SBGI code as Primary key)
SBGI CODE anedi School code

SO ippudu naku NY state lo Previous schooling chesina students list kavali ante.....I need to have Details table......ok....aadetails table ni i cant directly link to SBGI table......Coz andulo PIDM ledu  ...So wat i did was ....SHRD table lo  kavalsina 2 primry keys unnay kada ani....Details table ni SHRD table ki link chesi akkada nunchi SBGI table ki link chesa...

Say suppose....
this is how My table looks like after i runt he query...

PIDM    SBGI_ID          AGE    School    School_STATE_CODE
1            23                    ------------------      CO
2            34                    -------------              NY
2            65                ---------------              NY
3            43              ---------------------        MN
4            67                ----------------              CT

Which means OKa student number 2 ......1st oka school lo join ayyadu Which is in NY....AAtharvatha NY lo ne inko school ki transfer ayyadu....

Ippudu nenu NY lo PREV schooling chesin valla list thesthunte...EE number 2 .......two times vasthunnadu...Coz of DIff School....

So Ippudu naku em kavalante......I wan Only Unique values of PIDMS i dnt care abt SBGI_ID. SELECT UNIQUE try chesa...but dint wrk....
This is my 1st prblm

Prblm 2) database table lo ila store chesi undi

PIDM    SBGI_ID          AGE    School    School_STATE_CODE
1            23                    ------------------      CO
2            34                    -------------              NY
2            65                ---------------              MN

Which means....Student Number 2.......!st NY lo school lo join ayyaka.....MN lo school ki transfer ayyadu...
So naku NY query lonu....vasthunnadu.....MN query lonu.... vasthunnadu..........

clear ga cheppataniki chala try chesa....

[/quote] first daniki distint ane keyword use cheyyi....  select distinct vadithe set ayidhi.....  sHa_fr1ends sHa_fr1ends