" /> Wagwoord <br /><input type="password" name="passwd" id="passwd" class="inputbox" size="18" alt="password" />
Home SQL Inner lid
SQL Inner lid
PDF Let wel

INNERLIKE JOIN

SQL INNERLIKE JOIN sintaksis

1
2
3
4

KIES (s)
VANAF table_name1
INNERLIKE JOIN table_name2
OP table_name1.=table_name2.

- INNERLIKE JOIN is dieselfde as 'n lid.

Voorbeeld SQL INNERLIKE JOIN

Есть таблица "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

Nou wil ons alle persone wat 'n bevel te kies.

1
2
3
4
5

KIES Persone.Language, Persone.Noemnaam, Bestellings.OrderNo
VANAF Persone
INNERLIKE 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

 
+11 #1 Dinesh 2010-06-25 17:42
 
 
+15 #2 student 2010-08-09 20:46
 
 
0 #3 Irina 2010-10-20 09:31
 
 
-2 #4 nekulin 2010-12-29 09:46


 
 
0 #5 Piotr 2011-03-31 14:57
 
 
-3 #6 FilBV 2011-04-28 15:27

 
 
+3 #7 fibi 2012-02-23 20:22
 
 
0 #8 zur4ik 2012-03-21 14:47
 
 
0 #9 Дмитрий 2012-05-12 20:43



of




of



 

Magtiging

Nice Ajax Poll

Statistiek

Adverteer
© 2009 ageent.ru.