Please help with mysql query...

[richie]

I have two db tables:

Table 1: tableOne

_________________
col1 | col2 | id |
_________________
val1 | val2 | 0 |
_________________


Table 2: tableTwo
_________________________
col1 | col2 | id | T1_ID |
_________________________
val1 | val2 | 0 | 0 |
_________________________

I want to select values from tableOne where tableOne.id equals tableTwo.T1_ID.

Here's the query:

SELECT col1, col2 from tableOne a, tableTwo b WHERE a.id = b.T1_ID

The query is producing the error:
Supplied argument is not a valid MySQL result resource.

What am I doing wrong?

TIA,
Richie.

[richie]

I got it to work.

SELECT a.col1, a.col2 from tableOne a, tableTwo b WHERE a.id = b.T1_ID