" /> Module Nice Ajax Poll
" onclick="window.open(this.href,'win2','status=no,toolbar=no,scrollbars=yes,titlebar=no,menubar=no,resizable=yes,width=640,height=480,directories=no,location=no'); return false;" rel="nofollow">

Синтаксис SQL 

1
2
3
4

KIES (s)
VANAF table_name1
 JOIN table_name2
OP =

- В некоторых базах данных имеет имя LEFT OUTER JOIN.

Пример 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 OP Bestellings
ORDER BY Persone.P_Id=Bestellings.P_Id
Voeg kommentaar by Persone.Language

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

 
-1 #1 Nerses 2010-10-04 13:56 Hansen,
Hansen,
 
 
+8 #2 aquillaman 2010-10-17 17:43
Hansen,
Hansen,
 
 
+4 #3 aquillaman 2010-10-17 17:44
Hansen,
Hansen,
 
 
+10 #4 INet 2011-02-25 14:50
 
 
+2 #5 skinny 2011-03-19 19:19
 
 
+3 #6 Krot 2011-03-31 20:01
 
 
0 #7 Member 2011-03-31 22:52


 
 
+1 #8 Alex-x 2011-04-29 11:43
 
 
0 #9 Allexxisss 2012-02-28 15:30
 

Magtiging

Nice Ajax Poll

Statistiek

Adverteer
© 2009 ageent.ru.