Base table or view not found HELP!

[imperium2335]

Hi,

 

Does anyone know why it won't recognise my abstract table?

 

I get the error " PDO::query() [pdo.query]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'overseer_ims.invoicetable' doesn't exist"

 

SELECT

    (SELECT SUM(invoiceTable.total) FROM invoiceTable WHERE invoiceTable.jobRef = jobs.id) AS total

FROM invoices_out, jobs, invoices_out_reference, enquiries, entity_details,
    (SELECT jobRef, SUM(invoices_out.net+invoices_out.vat) AS total
        FROM invoices_out, invoices_out_reference
        WHERE invoices_out_reference.invoiceRef = invoices_out.id
        GROUP BY jobRef)
    AS invoiceTable

WHERE invoices_out_reference.jobRef = jobs.id
AND invoices_out_reference.invoiceRef = invoices_out.id
AND enquiries.id = jobs.enquiryRef
AND invoiceTable.jobRef = jobs.id
AND enquiries.entityRef = entity_details.id

[imperium2335]

*bump*

[fenway]

You have two things called "invoiceTable"?

[imperium2335]

Thanks for your reply. No, I only have one thing called invoiceTable, and that is the abstract one I'm creating in this query, no other tables exist with that name.

[fenway]

You can't use a subquery to examine a table created in another subquery.