20201015

<join실습>

select * from jdcWebLink$
join jdcWebNode$ on jdcWebLink$.target=jdcWebNode$.id
where source='자경전'

use s_phj

• 모든 테이블을 보여줘라

select * from sys.tables

/*
jdcDomainNode$
jdcPhotoNode$
jdcWebNode$
*/

select * from jdcPhotolink$
select * from jdcDomainNode$

where label='자경전'
select * from jdcWebNode$

select * from jdcPhotoLink$ 
join jdcPhotoNode$.target on jdcPhotoLink$.id

select * from jdcWebLink$
join jdcWebNode$ on jdcWebLink$.target=jdcWebNode$.id
where source='자경전'

select * from jdcDomainNode$
select class, groupName, partName, count(*) from jdcDomainNode$
group by class, groupName, partName
order by class, groupName, partName

select * from jdcPhotoNode$

create table jdcPhotoNode (
id nvarchar(40) not NULL,
class nvarchar(40) NULL,
groupName nvarchar(40) NULL,
label nvarchar(80) NULL,
infoUrl nvarchar(256) NULL,
iconUrl nvarchar(256) NULL,
note nvarchar(256) NULL,
primary key(id)
)

select * from jdcPhotoNode

insert into jdcPhotoNode(id, class, groupName, label, infoUrl, iconUrl)
select id, class, groupName, label, infoUrl, iconUrl from jdcPhotoNode$
select * from jdcPhotoNode

insert into jdcPhotoNode (id, label)
values
('새로_찾은_사진_001', '데이터베이스_수업1')