" /> Wagwoord <br /><input type="password" name="passwd" id="passwd" class="inputbox" size="18" alt="password" />
PDF

Синтаксис SQL

1
2
3
4
KIES (s)
VANAF table_name1
 JOIN table_name2
OP table_name1.=table_name2.

Пример SQL

Есть таблица "Persone":

P_Id Language Noemnaam Address Stad
1 Hansen Ola Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Kari Storgt 20 Stavanger

Daar is 'n tafel "ordes":

O_Id OrderNo P_Id
1 77895 3
2 44678 3
3 22456 1
4 24562 1
5 34764 15

1
2
3
4
5
KIES Persone.Language, Persone.Noemnaam, Bestellings.OrderNo
VANAF Persone
 JOIN Bestellings
OP Persone.P_Id=Bestellings.P_Id
ORDER BY Persone.Language

Language Noemnaam OrderNo
Hansen Ola 22456
Hansen Ola 24562
Kari 77895
Kari 44678
Svendson Tove
34764

Magtiging

Nice Ajax Poll

Statistiek

Adverteer