create a relation between two tables mysql

[karthika44]

i have two tables, employee details table(empno, emp_name , branch) and attendance table(date, Ot, attendence). I want to create a relation between two tables

[Phi11W]

Since the two tables have no fields in common, I assume you want a linking table ("Weak Entity") between the two, something like this: 

create table employee_attendance 
( empno ... 
, att_date ... 
, Ot ... 
, primary key ( empno, att_date, Ot ) 
, foreign key empno references employee ( empno )
, foreign key ( att_date, Ot ) references attendance( att_date, Ot )
); 

I'm guessing at the primary Key for the attendance table here - an employee would attend something ("Ot?") on a given date.  

Don't use reserved words, like date, for table or column names.  Eventually, it will come back to bite you.

Regards, 
  Phill W.