[Resolved] Mysql : clause is ambiguous

[hsob]

I have a query:

$query = "SELECT ComingSoon.,CurrentlyShowing. FROM ComingSoon,CurrentlyShowing where film_name='$film'";

and this is resulting in the error:
Query failed : Column: 'film_name' in where clause is ambiguous

Im not sure what this means? and how to fix it?
I have tested $film and it does contain the right variable.
Thank you,
Kind Regards

[mtimdog]

Which table is it coming from?? if from the second...you could put CurrentlyShowing.film_name.

If you're trying to query both tables, you could use a union query(if your version of mysql is new enough) or 2 queries since it looks like the two tables aren't 'linked'.