Any SQL gurus out there? I have a question.

I am looking at doing something in SQL, but my knowledge of SQL is low and self-taught. I was wondering if there are any SQL people out there who can help me.
(If it helps, I'll likely be doing this on MySQL).

So, I have two list of items (lista and listb), each of arbitrary length. The size of the lists will chnage over time independent of each other. However, items from lista can be pairs with items from listb. Each pairing produces a value. I want to be able to, given an item from each list, get the appropriate value of the pairing. This is easy to do on paper (i.e. draw a grid and make lista the rows, listb the columns and fill in the blocks). It's easy to do with a dynamically sized multidimensional array. But how would I do this in SQL?

Posted via email from Xyphoid Musings