How to compare to different table coloms and matched coloms fetch all rows from table one? : i am compairing two tables single coloms and matched coloms fetch all rows

select * from t_registered_std_info
where t_registered_std_info.t_ds_name == attendance.std_name