Problem with Query

[Anon]

Hi.

I got two tables ('table1', 'table2'). Now I want to select all entries in 'table1' for which is set a specific value in 'table2'.

Ex:

'table1':

id | fid | text

1 1 bla
2 1 foo
3 2 blu

'table2':

id | fid | check

1 1 ok
2 1 ok
3 1

Means I want to get all results from table1 which got e.g. fid=1 and check=ok.

How would I do that? Thanks.

[hitatma1]

dear friend ,
u refer to the join query in mysql,so by that way u can join both the tables and then execute the select query using the where statement,

try this...else i will send the query in the next instance.
hitesh

[Anon]

select t1.id, t1.fid, t1.text from t1, t2 where t2.fid='1' and t2.check='ok' and t1.fid=t2.fid;
Hopping that you have used fid to relate the two tables.
where t1 : table1
t2 : table2

[Anon]

Well, thanks so far.

This works. But what if I want to select the entries with check=''? This does not seem to work...

select t1.id, t1.fid, t1.text from t1, t2 where t2.fid='1' and t2.check='' and t1.fid=t2.fid;

[christt]

It's better to use:

1 for OK.
0 for NOT OK.