Join

Let us create another table :
CREATE table truckname(id INTEGER, name VARCHAR(80));
INSERT INTO truckname VALUES('1', 'mytruck');

QUERY:
SELECT * FROM trucks, truckname WHERE trucks.id = truckname.id;
OUTPUT:
id | xpos_2_3 | ypos | cargo_4 | id | name
1 | prod(norm(1 , 2)#204, norm(1 , 2)#205) | NULL | hist(1 , 2: 0.5 , 0.5)#206 | 1 | mytruck



Rohit Jain 2011-08-02