[SOLVED] Combine 2 SQL queries?

[ale1981]

Is it possible for me to combine these 2 SQL queries so I just get a combined Sales figure from both tables?

 

SELECT     SUM(SUBTOTAL) AS Sales
FROM         SOP30200
WHERE     (CUSTNMBR = 'HLS0003') AND (SOPTYPE = 2) AND (PRSTADCD = '0012')

SELECT     SUM(SUBTOTAL) AS Sales
FROM         SOP10100
WHERE     (CUSTNMBR = 'HLS0003') AND (SOPTYPE = 2) AND (PRSTADCD = '0012')

 

Thanks in advance.

[Barand]

perhaps

SELECT     SUM(x.SUBTOTAL) AS Sales
FROM (
    SELECT     SUBTOTAL
    FROM         SOP30200
    WHERE     (CUSTNMBR = 'HLS0003') AND (SOPTYPE = 2) AND (PRSTADCD = '0012')
    UNION ALL
    SELECT     SUBTOTAL
    FROM         SOP10100
    WHERE     (CUSTNMBR = 'HLS0003') AND (SOPTYPE = 2) AND (PRSTADCD = '0012')
) as x

[ale1981]

Thanks v much, works a treat.