Help with self join - cannot get it to work (2 replies)
(MySQL.com) Hello
I need to create a self join a table.
CREATE TABLE ovp.test (
id INT NOT NULL AUTO_INCREMENT,
date DATETIME,
machine_name VARCHAR(250),
image_name VARCHAR(250),
disk_used_percentage DOUBLE(16,2) default NULL,
PRIMARY KEY (id)
);