[RESOLVED] Every derived table must have its own alias

cluelessPHP

I'm attempting this query as the title suggests I'm getting the error message Every derived table must have its own alias

SELECT SQL_CALC_FOUND_ROWS ads.img_id, ads.groupList, 
								ads.ad_id, ads.adName, img_upload.id, img_upload.img_path
									FROM ads
										INNER JOIN admin
									ON admin.ad_id=ads.ad_id
										INNER JOIN img_upload
									ON img_upload.id=admin.id
                                    	LEFT JOIN address
									ON ads.ad_id=address.ad_id
                              LEFT JOIN(SELECT address.address_id AS customerAddress FROM address GROUP BY ad_id) 
									WHERE adCost = 'economy'
								ORDER BY ads.ad_id DESC

laserlight

I suggest formatting the SQL statement to be something like this:

SELECT SQL_CALC_FOUND_ROWS ads.img_id, ads.groupList, ads.ad_id, ads.adName,
                           img_upload.id, img_upload.img_path
    FROM ads
        INNER JOIN admin ON admin.ad_id=ads.ad_id
        INNER JOIN img_upload ON img_upload.id=admin.id
        LEFT JOIN address ON ads.ad_id=address.ad_id
        LEFT JOIN (SELECT address.address_id AS customerAddress FROM address GROUP BY ad_id)
    WHERE adCost='economy'
    ORDER BY ads.ad_id DESC

Then telling us the exact error message, including whatever portions of the SQL statement that are highlighted.

Anyway, I suspect that you're being told that this:

LEFT JOIN (SELECT address.address_id AS customerAddress FROM address GROUP BY ad_id)

should have been:

LEFT JOIN (SELECT address.address_id AS customerAddress FROM address GROUP BY ad_id) AS customer_addresses

or something along these lines.

cluelessPHP

I just realized that too, rather silly thing to do, I'm about to test selecting it..

SELECT SQL_CALC_FOUND_ROWS ads.img_id, ads.groupList, 
								ads.ad_id, ads.adName, img_upload.id, img_upload.img_path, exm.address_id
									FROM ads
										INNER JOIN admin
									ON admin.ad_id=ads.ad_id
										INNER JOIN img_upload
									ON img_upload.id=admin.id
                                    	LEFT JOIN address
									ON ads.ad_id=address.ad_id
                              LEFT JOIN(SELECT address.address_id FROM address GROUP BY address.ad_id) as exm
                              			ON ads.ad_id=address.ad_id
									WHERE adCost = 'economy'
								ORDER BY ads.ad_id DESC

cluelessPHP

Which is displaying as NULL?

cluelessPHP

It just hit my I already have an identifier, I'm an idiot... thanks laserlight