create table myone (
id counter,
alias varchar (255),
path longchar,
creationdate varchar (20),
lastUseddate varchar (30),
totaltables integer,
selection bit
);
insert into myone (alias, path, selection) values ("two","c:\two",1);
delete * from myone where id <= 7;
select left(path,len(path)) as mypath from myone;
select products.productid as a,
products.productname as b,
categories.categoryname as c
from categories inner join products
on categories.categoryid = products.categoryid;