CREATE TABLE "models" (
"_id" INTEGER PRIMARY KEY  NOT NULL ,
"name" TEXT NOT NULL  DEFAULT (null) ,
"price" INTEGER NOT NULL )

INSERT INTO "models" VALUES(1,'BMW',55000);
INSERT INTO "models" VALUES(2,'AUDI',62000);
INSERT INTO "models" VALUES(3,'OPEL',42000);
INSERT INTO "models" VALUES(4,'MERCEDES',72000);

CREATE TABLE "properties" (
"_id" INTEGER PRIMARY KEY  NOT NULL , 
"model_id" INTEGER NOT NULL , 
"quantity" INTEGER NOT NULL  DEFAULT 0, 
"year" INTEGER DEFAULT 0)

INSERT INTO "properties" VALUES(1,2,5,2010);
INSERT INTO "properties" VALUES(2,4,9,2012);

SELECT models._id, name, price, quantity, year FROM models JOIN properties ON models._id=model_id

SELECT models._id, name, price, IFNULL(quantity, 0) AS quantity, IFNULL(year, 0) AS year FROM models LEFT JOIN properties ON models._id=model_id