sql

sql


create database sqlogreniyorum

create table calisanlar(

calisanId int not null,

ad varchar(50) not null,

soyad varchar(50) not null,

email varchar(50) not null,

tcNo varchar(11) not null,

maas money not null,

departmanId int not null

)


create table departman(

departmanId int not null,

departmanAdi varchar(50) not null

)

select ad, soyad, departmanAdi from calisanlar as c

inner join departman as d on c.departmanId=d.departmanId