hi,,,,
please anyone can help me and tell me what's wrong in my query,,,

first, this is my query:
select id, F1, F6 from jos_ckforms_1 where id=101 or F6=101 or
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101) or
F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101))
or F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101)));

i have tested my query above, it works!!!

than,,,
i try to run this query(second query):
SELECT id, F1, F6 from jos_ckforms_1 where id=101 OR F6=101 OR
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101) OR
F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101))
OR F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101))) OR
F6 = any(select id from 'jos_ckforms_1' WHERE
F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101))));

but it did'nt work,
whereas i just add:
OR
F6 = any(select id from 'jos_ckforms_1' WHERE
F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101))))
to first query,,,,

ohhh,,, i became crazy,,,,
what's wrong in my second query?
please anyone explain to me,,,,
"i attached an error message picture"
please,,,,

Creating your own syntax is fun but tends to lead to errors. Try looking at the manual for MySQL to see the syntax allowed in selects. What does the ANY() command do? Why do you say WHERE but then have no where condition? Can you put into English what you expected the SQL to do? You just seem to be endlessly checking that field id or F6 is equal to 101. Giving decent names to your tables and fields will also improve the readability.

also, since everything is ORed together, I hope your table never gets really big as you will more than likely being scanning every row of the table.

thanks mike_bike_kite, thanks dav1mo
i've got a solution,,,
this is my query:
select id , F1 , F6 from jos_ckforms_1 where id=101 or F6=101 or
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101) or
F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101))
or F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101)
or
F6 = any(select id from `jos_ckforms_1` WHERE
F6 = any(select id FROM `jos_ckforms_1` WHERE F6=101))));

this query just for getting information where F6 is referal_id and 101 is a lone key id to get others id.
again, thanks all,,,,