ryan010101
Technical User
I have two tables. One lists SKUs that are on "programs". The other table has sales info for all SKUs we sell, not totally up (each record is a line item on an order, so the SKU repeats many times).
I have a page which displays all the info for the particular program (stored in a table different from the above two) and then it displays what SKUs are on that program. In the list of SKUs that are on the program I would like to display the sales total for that particular SKU.
This is the current SQL statement
SELECT items_on_programs.*, FROM items_on_programs WHERE items_on_programs.program_id = " & request("id")
What needs to be done to not just grab the SKUs on a particular program but also grab the sales total for those SKUs from the other table?
thanks
Ryan
I have a page which displays all the info for the particular program (stored in a table different from the above two) and then it displays what SKUs are on that program. In the list of SKUs that are on the program I would like to display the sales total for that particular SKU.
This is the current SQL statement
SELECT items_on_programs.*, FROM items_on_programs WHERE items_on_programs.program_id = " & request("id")
What needs to be done to not just grab the SKUs on a particular program but also grab the sales total for those SKUs from the other table?
thanks
Ryan