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
