Inner Join sub select query help

I am new to this type of query and while I've found a lot of help on
the forums, I am simply not getting it to work.

Here is my attempt currently:

SELECT DISTINCT(VADR.SUBSCRIBER_ID),
VADR.ACCOUNT_DESC,
VADR.COUNTY_NAME,
VADR.STREET_NO,
VADR.STREET_NO_SUFFIX,
VADR.STREET_DIR_PREFIX,
VADR.STREET_NAME,
VADR.STREET_SUFFIX,
VADR.ADDL_LOC_INFO
FROM V_AC_LND_SRV_ADR AS VADR
INNER JOIN
(SELECT SUM(ACBL.LAST_TOTAL_DUE)
FROM AC_BALANCE ACBL)
ON VADR.SUBSCRIBER_ID = ACBL.SUBSCRIBER_ID
WHERE VADR.CITY_NAME = '#FORM.LOC#'
AND VADR.ACCT_TYPE = '#FORM.TYP#'

Can anyone educate me on an proper MySQL inner join select query syntax?

re: Inner Join sub select query help

GrungyApe wrote:[color=blue]
> Can anyone educate me on an proper MySQL inner join select query syntax?[/color]

The issue is here:

FROM V_AC_LND_SRV_ADR AS VADR
INNER JOIN
(SELECT SUM(ACBL.LAST_TOTAL_DUE) FROM AC_BALANCE AS ACBL)
AS ACBL2
ON VADR.SUBSCRIBER_ID = ACBL2.SUBSCRIBER_ID

The table alias ACBL you were using doesn't count outside the subquery.
So you have to give the derived table an alias, for instance ACBL2,
and use that alias in the join condition.

Regards,
Bill K.