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')