/*SEARCH BY PROJECT NAME*/

SELECT items . * , matters . * , bins . *
FROM items, matters, bins
WHERE items.f_num = matters.f_num
AND matters.name LIKE  "%kProject_Name%"

/*SEARCH BY F NUMBER*/

SELECT items . * , bins . *
FROM items, bins
WHERE items.f_num AND bins.f_num = "F_Number"

/*SEARCH BY MATTER NUMBER*/

SELECT items . * , matters . * , bins . *
FROM items, matters, bins
WHERE items.f_num = matters.f_num
AND matters.number LIKE  "matter number" 

/*SEARCH BY SLOT*/

SELECT items . *, bins . *
FROM items, bins
WHERE bins.f_num = items.f_num
AND bins.slot LIKE  "slot" 

/*SEARCH BY BIN BARCODE*/

SELECT items . * , bins . *
FROM items, bins
WHERE bins.f_num = items.f_num
AND bins.barcode = "bin_barcode" 


/*SEARCH BY ITEM BARCODE*/

SELECT items . *
FROM items
WHERE items.barcode = "item_barcode"


/*SEARCH BY ITEM SERIAL*/

SELECT items . *
FROM items
WHERE items.serial = "item_serial"