how to join the Tables
Hi there i am trying to join two tables std_entry_master and
std_parent_info. here is my code to join the tables:
select Student_F_Name,Student_M_Name ,Student_L_Name
,std_entry_master.ID,std_entry_master.Student_ID,
Section_ID,Contact_Name from std_entry_master join std_parent_info on
'STU00000060'=std_parent_info.Student_ID
where std_entry_master.Student_ID = 'STU00000060';
although it works fine when it finds STU00000060 in Student_ID column in
std_parent_info table but when it doesn't finds STU00000060 it gives me
the empty resultset. Is there any way to view rest of the column except
Contact_Name if STU00000060 is not present in std_parent_info table
No comments:
Post a Comment