How to run INNER JOIN
I'm Having Issues with this:

I have Two Tables star_info, movie_info, 

star_info has : star_id,Star_name, star_lastname;

and movie_info has:  movie_name,tagline,star_id;

i'm trying to run Quarry  

$sql = mysql_query("SELECT *  FROM movie_info INNER JOIN  movie_info ON movie_info.star_id = star_info.star_name") or die(mysql_error()); 

All i wants to Get is the star_id  from movie_info and show Star Name from star_info table.
which they are stored and show user a star name to related movies.

please help.


 
How to run INNER JOIN
===

I'm Having Issues with this:

I have Two Tables star_info, movie_info, 

star_info has : star_id,Star_name, star_lastname;

and movie_info has:  movie_name,tagline,star_id;

i'm trying to run Quarry  

$sql = mysql_query("SELECT *  FROM movie_info INNER JOIN  movie_info ON movie_info.star_id = star_info.star_name") or die(mysql_error()); 

All i wants to Get is the star_id  from movie_info and show Star Name from star_info table.
which they are stored and show user a star name to related movies.

please help.


 