MYSQL

/*SEARCH BY PROJECT NAME*/SELECT items . * , matters . * , bins . *FROM items, matters, binsWHERE items.f_num = matters.f_numAND matters.name LIKE  "%kProject_Name%"/*SEARCH BY F NUMBER*/SELECT items . * , bins . *FROM items, binsWHERE items.f_num AND bins.f_num = "F_Number"/*SEARCH BY MATTER NUMBER*/SELECT items . * , matters . * , bins . *FROM items, matters, binsWHERE items.f_num = matters.f_numAND matters.number LIKE  "matter number" /*SEARCH BY SLOT*/SELECT items . *, bins . *FROM items, binsWHERE bins.f_num = items.f_numAND bins.slot LIKE  "slot" /*SEARCH BY BIN BARCODE*/SELECT items . * , bins . *FROM items, binsWHERE bins.f_num = items.f_numAND bins.barcode = "bin_barcode" /*SEARCH BY ITEM BARCODE*/SELECT items . *FROM itemsWHERE items.barcode = "item_barcode"/*SEARCH BY ITEM SERIAL*/SELECT items . *FROM itemsWHERE items.serial = "item_serial"