Query breaks in MySQL 3.23+ Help

[ppowell]

		 $sql = 'DELETE album.* ' .
			    'FROM album AS a, album_section_type AS s ' .
			    'WHERE a.album_section_type_id = s.id ' .
			    " AND upper(s.album_section_type_name) = '" . strtoupper($section) . "' " .
			    " AND upper(a.album_name) = '" . strtoupper($album) . "' ";

The preceeding query works just fine in MySQL 4+ but produces the following error in MySQL 3.23+:

You have an error in your SQL syntax near 'album.* FROM album AS a, album_section_type AS s WHERE a.album_section_type_id =' at line 1

Is there a different SQL syntax to delete a specific record from 2 joined tables in MySQL 3.23+?

Thanx
Phil

[bubblocity]

Prior to 4, I think the functionality was kind of limited, like no subqueries.

I don't think it supported Delete on a JOIN either.