SQl Query Problem
-
hi to all My name is Devkranth .. i need help in sql.... i have 3 tables to retrieve data and display it.. there is no Primary key in any table.. but there is a common column , so if i join the tables i am getting rows duplicated... plz help me.. thanks in advance
-
hi to all My name is Devkranth .. i need help in sql.... i have 3 tables to retrieve data and display it.. there is no Primary key in any table.. but there is a common column , so if i join the tables i am getting rows duplicated... plz help me.. thanks in advance
hi, you can add identity column for these tables and join with this column. regards
jijo jose
-
hi to all My name is Devkranth .. i need help in sql.... i have 3 tables to retrieve data and display it.. there is no Primary key in any table.. but there is a common column , so if i join the tables i am getting rows duplicated... plz help me.. thanks in advance
after joining all tables use one of them and put a criteria like this --where fielname in ( select distinct fieldname from table1)-- this may solve the of duplicacy. Pradeep Shukla
-
hi, you can add identity column for these tables and join with this column. regards
jijo jose
hi jojo Thanks 4 ur reply.. i will just try it and come back to u..
-
after joining all tables use one of them and put a criteria like this --where fielname in ( select distinct fieldname from table1)-- this may solve the of duplicacy. Pradeep Shukla
thanks Pradeeop well will try it and get back soon..