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;