join two tables YET can't add veriables

this works...

$results=mysql_query
(" SELECT *
FROM groups, countries WHERE groups.ctst = countries.ctst
");

Yet when I try to add ANY where details OR even select a single field it errors.

$numresults=mysql_query

(" SELECT ctst
FROM groups, countries WHERE groups.ctst = countries.ctst
");

...and the query is? and the error is?

The reason is that both tables contain ctst field. So you have to do

SELECT countries.ctst
or
SELECT groups.ctst

Diego

$numresults=mysql_query

(" SELECT ctst
FROM groups, countries WHERE groups.ctst = countries.ctst
");

The query is what is above... The error is can't exicute query.

IF I do "SELECT * " the query is exicuted... If I define ANY fields ... I get can't exicute query'.

if I add any WHERE clause to this I also get 'can't exicute query.

It all comes down to the join table clause probably being the wrong syntax yes?

Fritz

So WHAT you are saying is that When i do a join ANY field that has the same name in both tables neeeds to be specified as...

table.field?

I just tried this and that appears to be the logic.

Why can't I find this info anywhere... and trust me I HAVE spent hours looking.

thank YOU so much for taking the time.

Fritz