Hi all,

Been a while since I've posted here but I'm back to doing some
database programming (using Access VB, which allows you to rapidly
code the front end GUI at the severe expense of some debugging tools).

Access apparently only allows your control (buttons, textboxes and the
like) to be bound to a single query or record source (dB), so here's
the problem:

I have a table, tblPQ, that has two columns, Product (P) and Quantity
(Q).  I want to take the product of P*Q for each row in the table,
then, take the sum of P*Q for the entire table.  Ideally I'd like to
do this with a SQL query; then I will bind this query to a button on
the front end form.  How to do this (write the SQL query that is)?

I looked in my textbook on SQL (I have several, including a
doorstopper by Itzik Ben-Gan "T-SQL Querying"), and though I got many
tantilizing hints, along the lines of SUM(x), "Self Join" and "UNION
SELECT", I couldn't quite get the right result.

Further, I'd like to add to the SQL query a equijoin (inner join),
because the table tblPQ shares a relationship with another table,
table ABC, sharing a column "id" (Primary Key/ Foreign Key), namely
"WHERE ABC.id = tblPQ.id"

Any ideas on what this SQL query would look like?

Thanks,

RL