I'm stuck.

The first step to getting a problem fixed is in stating the problem in ways that others can understand unambiguously. One diagnostic of how stuck you are is in the lack of clarity in your problem statement. I've read over your post several times, but to make sense of it I have to fill in everal gaps with assumptions and guesses. That's a warning flag. I say this to give you honest feedback, not to be mean.

If you repost the problem, please provide complete SQL DDL for both tables, along with notes of what the keys and foreign keys are.

I suspect that you're going to need a query like 

SELECT
  items.it_ID, items.it_Name, user_item_history.UserID
FROM
  items
  LEFT JOIN user_item_history
    ON items.it_ID = user_item_history.it_ID
WHERE user_item_history.UserID = ?
ORDER BY items.it_ID

[download]
This will give you a table with one row per item.it_ID, ordered by it_ID (which I assume is linearly ascending, and thus keeps it_Name in a sensible order). Thanks to the LEFT JOIN, the UserID column will be non-NULL if and only if the user has a history for the corresponding item.

Getting the results of the query into Perl data structures is left as an exercise.

In reply to Re: Newbie can't see the forest by dws
in thread Newbie can't see the forest by CrossEyedMonk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.