Thanks for your pointer. This SQL statement ended up working:
Thanks for your pointer! This ended up working for me:
SELECT * FROM profiles
LEFT JOIN allposters ON (profiles.titlesid = allposters.titlesid)
LEFT JOIN officialsites ON (profiles.titlesid = officialsites.titlesid)
LEFT JOIN titles ON
> I have a SQL statement that I use to grab movie profiles. When I
> constructed
> the input form, I decided I didn't want to use blank entries for
> tables that
> didn't have a entry for that particular film e.g. a poster wasn't
> available
> for sale.
>
> This SQL statement in PHP works fine
I have a SQL statement that I use to grab movie profiles. When I constructed
the input form, I decided I didn't want to use blank entries for tables that
didn't have a entry for that particular film e.g. a poster wasn't available
for sale.
This SQL statement in PHP works fine when EVERY table has
