book
books
where bib.Ref_ID not in (select distinct Ref_ID from fld_bib) 
select bib.*, fld_bib.*, folder.* from bib, fld_bib, folder where bib.Year_pub<1990 AND bib.Ref_ID=fld_bib.Ref_ID AND fld_bib.Folder_ID=folder.Folder_ID AND (folder.folder='Boronic Acid' OR folder.folder='Xylanase')
select bib.*, fld_bib.*, folder.* from bib, fld_bib, folder where bib.Year_pub<1990 AND bib.Ref_ID=fld_bib.Ref_ID AND fld_bib.Folder_ID=folder.Folder_ID AND folder.folder='Boronic Acid'
where Title is not null
where bib.Ref_ID not in (select distinct Ref_ID from fld_bib)
where Custom_1 like '%Motorcycle%' and (Keywords like '%Yamaha%' OR Keywords like '%yamaha%' OR Keywords like '%Harley-Davidson%' OR Keywords like '%harley-davidson%')
arlinz
atlanta
