Do you have two tables, and want to be able to calculate totals and merge information across them? Just join them together!
This isn’t even an ASP command, it’s just regular SQL. Let’s say you have two table, one with your sale items in it and another with your purchase information. You want to do a report to see how many of each item you’ve sold.