Scribd
Upload
43 views2 pages

+ Username + : Insert Into Select Left AS

The document contains examples of SQL queries that use SELECT statements to retrieve data from multiple tables joined together, as well as INSERT statements that copy data from one table to another or insert values including those from a subquery. It also demonstrates how to insert a row into a table by selecting columns from another table where conditions are met.

Uploaded by

brcko
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
43 views2 pages

+ Username + : Insert Into Select Left AS

The document contains examples of SQL queries that use SELECT statements to retrieve data from multiple tables joined together, as well as INSERT statements that copy data from one table to another or insert values including those from a subquery. It also demonstrates how to insert a row into a table by selecting columns from another table where conditions are met.

Uploaded by

brcko
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SELECT [Link], [Link], Users.datum_rodjenja, Users.

pol,
[Link],Student.studijski_program,[Link], Student.broj_indeksa from Student
inner join Users on [Link]=[Link];

SELECT [Link], [Link], Users.datum_rodjenja, [Link],


Referent.studijski_program,[Link] from Referent inner join Users on
[Link]=[Link];

Kad stavis ovako da izaberes branch otvoris samo iz github onog dokumenta I tjt I pokaze ti ono sto sam
ja tu radila , ako hoces na master kliknes master I on ti tamo sam menja document

"Select Predmeti.Naziv_predmeta,
[Link],[Link],[Link],Users
.prezime FROM Users INNER JOIN ((Profesor INNER
JOIN Predmeti ON
[Link]=Predmeti.Username_profesora)
INNER JOIN SlusaPredmet ON
Predmeti.Sifra_predmeta=SlusaPredmet.sifra_pred
meta) ON [Link]=[Link] WHERE
SlusaPredmet.username_student='" + username +
"'";
query = "Delete from Users WHERE username in (SELECT [Link] FROM Users q
INNER JOIN Referent u on [Link] = [Link] where [Link] = '" + username + "'";

ovako radi inace insert


INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode,
Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen
21', 'Stavanger', '4006', 'Norway');
Ovako bi bilo da kopira sadrzaj iz jedne tabele u drugu

1. INSERT INTO Customer (FirstName, LastName, City, Country, Phone)


2. SELECT LEFT(ContactName, CHARINDEX(' ',ContactName) - 1) AS
FirstName,
3. SUBSTRING(ContactName, CHARINDEX(' ',ContactName) + 1, 100)
AS LastName,
4. City, Country, Phone
5. FROM Supplier
6. WHERE Country = 'Canada

INSERT INTO column_1 ( val_1, val_from_other_table )


VALUES('val_1', (SELECT val_2 FROM table_2 WHERE val_2 = something))

INSERT INTO TABLE1


(COLUMN1, COLUMN2, COLUMN3, COLUMN4)
VALUES (value1, value2,
(SELECT COLUMN_TABLE2
FROM TABLE2
WHERE COLUMN_TABLE2 like "blabla"),
value4);

INSERT INTO [Link]


( UserID ,
Full_Name ,
Login_Name ,
Password
)
SELECT UserID ,
Full_Name ,
Login_Name ,
Password
FROM Users_Table
(INNER JOIN / LEFT JOIN ...)
(WHERE CONDITION...)
(OTHER CLAUSE)
INSERT INTO ordre_linie 
(SELECT * FROM dage, fk_ordre_id, navn, fk_kurve_id, antal, total_pris, fk_dag_id, dag_navn)
INNER JOIN dage ON ordre_linie.fk_dag_id = dage.dag_id 
VALUES (@fk_ordre, @navn, @kurv, @antal, @pris, @dag, @dag_navn) 
INSERT INTO newtable(value1, value2, value3)
SELECT value1N, value2N, value3N,(SELECT valueN4 FROM secondtable WHERE id='1')
FROM firsttable WHERE id='1');

You might also like