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