I have a query (in MySQL): SELECT l_partno, l_qty, i_login, FROM requirements_table, inventory_table WHERE requirements_table.l_partno = inventory_table.i_partno; Now, it is possible that one member (i.e. for one value of the login field) may have multiple entries for the same part number. e.g. i_login...