Learn Sql server in hindi/urdu part-23(one to one relationship)

create table car

(

car_id int identity primary key,

car_name nvarchar(20) not null,

car_model nvarchar(10) not null,



)



insert into car

values('Mehran','1980')



select * from car



create table employee

(

emp_id int identity primary key,

emp_name nvarchar(20) not null,

emp_desig nvarchar(20) not null,

emp_car_fk int unique foreign  key references car(car_id)



)











insert into employee

values('ahmed','officer',2)





select  e.emp_id,e.emp_name,e.emp_desig,c.car_id,c.car_model,c.car_name from employee e inner join car c on c.car_id=emp_car_fk