Could someone help me out with this SQL query? : I am asked this:

> Use a subquery in the FROM clause to only retrieve invoices from
> chamber 'H' and the invoice amount of larger than 10000 and join the
> result with the voyages table using the number column. Project to only
> retrieve the boatname and the invoice amount of the join result. Order
> by invoice amount.

So, I made this:

    SELECT chamber=(SELECT chamber FROM invoices INNER JOIN voyages ON chambers.chamber='H' AND chambers.invoice > 10000 AND invoice.number=voyages.number), boatname, invoice FROM chambers, voyages, invoices WHERE chambers.chamber=invoices.chamber, invoices.number=voyages.number

*This is the chambers table:*

    #	chamber	  name
    1	  A	     New York

*This is the invoices table:*
    
    #	number	invoice	chamber
    1	8300	9189	A

Yet it keeps giving me this error: `Query failed: near ",": syntax error`

I can't solve it. Could someone help me out?
