bp 10 spajanje 2016 .pdf

File information


Original filename: bp_10_spajanje_2016.pdf
Title: BP 10 SPAJANJE 2016
Author: Dana

This PDF 1.4 document has been generated by PDFCreator Version 1.7.2 / GPL Ghostscript 9.10, and has been sent on pdf-archive.com on 02/09/2016 at 11:24, from IP address 147.91.x.x. The current document download page has been viewed 351 times.
File size: 289 KB (15 pages).
Privacy: public file


Download original PDF file


bp_10_spajanje_2016.pdf (PDF, 289 KB)


Share on social networks



Link to this file download page



Document preview


VEZE

1:1

1

1:N

M:N

2

SPAJANJE TABELA

SPAJANJE TABELA

3

SPAJANJE TABELA
prikazivanje podataka iz više tabela
može biti - implicitno
- eksplicitno
Koriste se kvalifikovana imena

Ime_tabele.Ime_kolone

KVALIFIKOVANA IMENA
Ime_tabele.Ime_kolone

4

KVALIFIKOVANA IMENA
U okviru istog izraza mogu se
kombinovati kvalifikovana i
nekvalifikovana imena
SELECT rad_id, radnici.grad
.............
SELECT rad_id, r.grad
....................

Alijas tabele
Alijas je jedna reč, bez navodnika,
sadrži slova, cifre, donje crte.
Ne treba koristiti razmake, znakove
interpunkcije i specijalne znake.
U FROM ili JOIN rečenicu uneti
Sintaksa: tabela [AS] alijas

5

DOSLEDNO KORIŠĆENJE

UPOTREBA ALIJASA

SELECT r.rad_ime, r.odelj_id, o.odelj_ime
FROM radnici r, odeljenja o
WHERE r.odelj_id = o.odelj_id;

6

BITNO
Postoje samo tokom trajanja iskaza
Ne pojavljuju se u rezultatima (za
razliku od alijasa kolona)
Ne menjaju ime tabele u BP

SINTAKSA

7

CROSS JOIN – UNAKRSNO
SPAJANJE
SELECT kolone
FROM tabela1
CROSS JOIN tabela2
.....
CROSS JOIN tabelaN;
EKVIVALENTNO
SELECT kolone
FROM tabela1, tabela2,..., tabelaN;

CROSS JOIN – UNAKRSNO
SPAJANJE

……

8

CROSS JOIN – UNAKRSNO
SPAJANJE

SELECT *
FROM tabelaA INNER JOIN TabelaB
ON TabelaA.ime = TabelaB.ime;

9


Related documents


bp 10 spajanje 2016
sqlpriru nik
family tree delalic
rsdb
seminar 1 2 odi
orientering om prosjekt hele

Link to this page


Permanent link

Use the permanent link to the download page to share your document on Facebook, Twitter, LinkedIn, or directly with a contact by e-Mail, Messenger, Whatsapp, Line..

Short link

Use the short link to share your document on Twitter or by text message (SMS)

HTML Code

Copy the following HTML code to share your document on a Website or Blog

QR Code

QR Code link to PDF file bp_10_spajanje_2016.pdf