samedi 26 mars 2016

SQL, print the amount for each model

I'm haven't enough expirience in construstion SQL-query yet. I have a 2 table:


producers (

prod_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
prod_title text

);

models (

prod_id NOT NULL, 
model_name text, 
FOREIGN KEY (prod_id) REFERENCES producers(prod_id)

);


How do I get a table of the form:

column1.............column2

producer1...........the amount of models producers1

producer2...........the amount of models producers2

...

producerN...........the amount of models producerN

Aucun commentaire:

Enregistrer un commentaire