[MyPornLife.info]

field "ID" is in table: first (its an INT field)
field "IDs" is in table: second (its a VARCHAR field)

so "ID" & "IDs" two different field in deferent table.

"ID" contains a single unique number
but "IDs" contain some id. i.e- 14,15,16,17,118

so i think ON is not a good idea...coz they never be equal.
thats why IN must be used.

plz read my both codes of first post very carefully again...so it will be clear to u
& plz help me

& sorry for the confusing post

--------------- Added [DATE]1260613675[/DATE] at [TIME]1260613675[/TIME] ---------------

hey i tried this:

PHP Code:

$query = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "first AS first
    LEFT JOIN " . TABLE_PREFIX . "second AS second
    ON (first.ID IN (second.IDs)) WHERE second.pID = $pID"); 


its not showing error but incomplete result.
i mean it returns just only one table although it shud show more as there r more row according to condition.