SELECT borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.cardnumber, borrower_attributes.code, borrower_attributes.attribute FROM borrowers LEFT JOIN borrower_attributes ON (borrowers.borrowernumber=borrower_attributes.borrowernumber) LEFT JOIN borrower_attribute_types ON (borrower_attribute_types.code=borrower_attributes.code) GROUP BY borrower_attributes.attribute ORDER BY borrowers.surname, borrowers.firstname ASC
Résultat :
Exemple pour le module adhérent : SELECT borrowers.cardnumber AS numero_carte, borrowers.surname AS Nom, borrowers.firstname AS Prenom, borrowers.email AS email_principal, borrowers.emailpro AS email_alternatif, […]
Il existe quelques catégories de valeurs autorisées qui sont créées automatiquement lors de l’installation de Koha. (Remerciements : http://koha.zone.ccsr.qc.ca/valeurs-autorisees/) Asort1 et Asort2 […]
Un exemple vaut parfois mieux que de longues explications : SELECT biblio.datecreated AS Date_creation, biblio.title AS Titre, biblio.author AS Auteur, items.itemcallnumber AS […]
SELECT * FROM nom_de_la_table LIMIT 5 Exemple : TABLE branches SELECT * FROM branches LIMIT 20
