I am trying to combine data from two tables, Item and Supplier.  Item
has a field called sku which must be unique.  Supplier contains vendor
names and vendor part numbers for each sku, but there can be multiple
vendors per sku, each vendor can have its own vendor part number, and

Is there any way to get sql results into arrays rather than memory?
if SQLEXEC(nHandle, aArrayName) worked it would be great.

I have a table which is inventory by vendor, so it is possible there
are multiple vendors per item.  I would like to scan through the
table  and pick the first existence of each item, along with a few
other fields.  I believe I want to use a scan...endscan statement, and