create table mytwo (
  id  counter,
  alias  varchar (255),
  path  longchar,
  selection  bit
);
insert into mytwo (alias, path, selection) values ("three","c:\three",1);
insert into mytwo (alias, path, selection) values ("three","c:\three",FALSE);
/* select * from mytwo where selection = 1; no effect */
/* select * from mytwo where selection = "TRUE"; */
select * from mytwo where selection = TRUE;
delete * from mytwo where selection = TRUE;
select left(path,len(path)) as mypath from mytwo;
select products.productid as a,
	products.productname as b,
	categories.categoryname as c,
	suppliers.companyname as d
from (categories 
inner join products
on categories.categoryid = products.categoryid)
inner join suppliers
on suppliers.supplierid = products.supplierid
order by products.productid