|
|
STRUCTURE DE LA BASE terreneuvas :
- tncampagnes(ANNEE, BATEAU, DATE_DEPART, DATE_RETOUR, NB_MORUES, VENTE_NETTE, COMMENTAIRE, )
- tnembarquements(IDMARIN, ANNEE, BATEAU, DOMICILE, AGE, FONCTION, PART, NB_MORUES, BRUT_REEL, AVANCES, COMMENTAIRES, )
- tnfonctions(FONCTION, DORISSANT, COMMENTAIRE, )
- tnmarins(IDMARIN, NOM, PRENOM, NE_EN, )
- tnzones(COMMUNE, CODE, ZONE, DEPARTEMENT, )
PRINCIPAUX MOTS CLEFS SQL :
- SELECT, DISTINCT, AS, FROM, JOIN, LEFT JOIN, ON
- WHERE, IN, BETWEEN, LIKE, AND, OR, NOT, IS NULL, IS NOT NULL
- ORDER BY, DESC
- SUM(), AVG(), MAX(), COUNT(), COUNT(DISTINCT )
- GROUP BY, HAVING, UNION, SOME, ALL
|