Mr Mirchi Posted February 14, 2017 Report Share Posted February 14, 2017 Naaku oka column vundhi... e column lo ki values 3 primary key tables numdi vasthavi..... oka column ni 3 primary tables ki foreign key references pettichaaa P.S: e child column lo duplicate values expected Quote Link to comment Share on other sites More sharing options...
Bhai Posted February 14, 2017 Report Share Posted February 14, 2017 20 minutes ago, Mr Mirchi said: Naaku oka column vundhi... e column lo ki values 3 primary key tables numdi vasthavi..... oka column ni 3 primary tables ki foreign key references pettichaaa P.S: e child column lo duplicate values expected Sample data beyyi Quote Link to comment Share on other sites More sharing options...
former Posted February 14, 2017 Report Share Posted February 14, 2017 TABLE1, TABLE2, TABLE3 --> 3 tables vunayi. oka comon Primary Key (DISTINCT & NOT NULL) column vunda ? Danini nevu foreign key ga cheyali anukotunavu? Technical ga idi possible kadu anukonta. LTT for experts. Quote Link to comment Share on other sites More sharing options...
Spartan Posted February 14, 2017 Report Share Posted February 14, 2017 qn correct ga adugu.. @loveindia uncle cheptadu. Quote Link to comment Share on other sites More sharing options...
former Posted February 14, 2017 Report Share Posted February 14, 2017 LTT @loveindia Quote Link to comment Share on other sites More sharing options...
ICANWIN Posted February 14, 2017 Report Share Posted February 14, 2017 You can i believe but clear ga adugute confirmed ga cheppachu. Quote Link to comment Share on other sites More sharing options...
Mr Mirchi Posted February 14, 2017 Author Report Share Posted February 14, 2017 44 minutes ago, former said: TABLE1, TABLE2, TABLE3 --> 3 tables vunayi. oka comon Primary Key (DISTINCT & NOT NULL) column vunda ? Danini nevu foreign key ga cheyali anukotunavu? Technical ga idi possible kadu anukonta. LTT for experts. Yaaa table a , table b, table c vunnavi - primary tables veeti primary key value tabcle D lo oke column loki vasthunnavi... so column of table D is going to have values from table a,b,c .... so e column of table D ni pyna 3 tables ki foreign key reference pettichaa ani inka clear ga kavali ante student table - student.id (id primary key column) teacher table - teacher.id (id primary key) colleges - colleges.id (id column is primary key) transaction table - user_id column (dheeni values from 3 tables numdi) - so e column ni foreign key reference pettocha pyna 3 tables ki create table code raseppudu Quote Link to comment Share on other sites More sharing options...
Bhai Posted February 14, 2017 Report Share Posted February 14, 2017 34 minutes ago, Mr Mirchi said: Yaaa table a , table b, table c vunnavi - primary tables veeti primary key value tabcle D lo oke column loki vasthunnavi... so column of table D is going to have values from table a,b,c .... so e column of table D ni pyna 3 tables ki foreign key reference pettichaa ani inka clear ga kavali ante student table - student.id (id primary key column) teacher table - teacher.id (id primary key) colleges - colleges.id (id column is primary key) transaction table - user_id column (dheeni values from 3 tables numdi) - so e column ni foreign key reference pettocha pyna 3 tables ki create table code raseppudu pettochu. kani kalagapulagam la untadi use chesevallaki. Student ID, Teacher ID same unte ela identify chestavu??? -- Uniques unte. how do you identify it is a student or techer or college?? so, daniki inko identifier column add cheyyali table lo to identify teacher or student or college. Same column transaction table lo kooda undali. Quote Link to comment Share on other sites More sharing options...
MeetFriendz Posted February 14, 2017 Report Share Posted February 14, 2017 i dont think so .. oo table create chesi test cheyee .. simple ... Quote Link to comment Share on other sites More sharing options...
princeofheaven Posted February 14, 2017 Report Share Posted February 14, 2017 1 hour ago, Mr Mirchi said: Yaaa table a , table b, table c vunnavi - primary tables veeti primary key value tabcle D lo oke column loki vasthunnavi... so column of table D is going to have values from table a,b,c .... so e column of table D ni pyna 3 tables ki foreign key reference pettichaa ani inka clear ga kavali ante student table - student.id (id primary key column) teacher table - teacher.id (id primary key) colleges - colleges.id (id column is primary key) transaction table - user_id column (dheeni values from 3 tables numdi) - so e column ni foreign key reference pettocha pyna 3 tables ki create table code raseppudu CHeyoochu no problem.. Quote Link to comment Share on other sites More sharing options...
Mr Mirchi Posted February 14, 2017 Author Report Share Posted February 14, 2017 2 hours ago, MeetFriendz said: i dont think so .. oo table create chesi test cheyee .. simple ... Repu adhe cheyali office lo firat time sql server meedha working... oracle lo pacakges rasi anni stored procs pettochu... sql server lo packages concept ledhu anipisthumdhi chusthe Quote Link to comment Share on other sites More sharing options...
k2s Posted February 14, 2017 Report Share Posted February 14, 2017 Out of syllabus man Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.