-- Collection of code snippets by Arne Vajhøj 
-- (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) 
SELECT * FROM asset JOIN truckasset ON asset.id = truckasset.id;
SELECT * FROM asset JOIN trailerasset ON asset.id = trailerasset.id;
SELECT * FROM asset JOIN toolasset ON asset.id = toolasset.id;
