Voici un lien vers une formation complète pour MySQL
http://abusus.lost-oasis.net/article5.html
Forum Programmation.SQL Cours complet MySQL
26
avr.
2006
select a.*,
b.met_id,b.met_lib,
h.fct_id,
c.fct_lib,
d.ct_id,d.ct_lib,j.ct_valide,
e.typ_id,e.typ_lib,
f.notfct_val,
i.ser_lib
from
collaborateurs a,
metiers b,
fonction c,
competences_tech d,
type_ct e,
li_col_ct_fct f,
li_col_met g,
li_col_fct h,
service i,
LI_MET_TYP_CT j
where
(a.col_id=g.col_id(+)
and g.met_id=b.met_id(+))
and (a.col_id=h.col_id(+)
and h.fct_id=c.fct_id(+))
and (f.col_id=a.col_id and f.met_id=b.met_id (...)
No. Time Source Destination Protocol Info 3 *REF* 192.168.12.21 192.168.12.251 TCP 4353 > 3306 [SYN] Seq=0 Ack=0 Win=65535 Len=0 MSS=1460 4 0.000249 192.168.12.251 192.168.12.21 TCP 3306 > 4353 [SYN, ACK] Seq=0 Ack=1 Win=5840 Len=0 MSS=1460 5 0.000282 192.168.12.21 192.168.12.251 TCP 4353 > 3306 [ACK] Seq=1 Ack=1 Win=65535 (...)
Champ1 Champ2 Champ3
Del 2 oui
Null 2 oui
(...)