[RESOLVED] mysql query

[moraru]

hello

I run in this dilema and I need some help to the following query:

I have 2 tabels:

[FONT=Arial]table USERS

| db_user | db_pass | db_email | db_verified |

| george | 1234 | email1 | 1 |

| andy | 1224 | email2 | 0 |

table BOOKS

| db_book | db_title | db_user |

| book1 | title1 | george |

| book2 | title2 | george |

| book3 | title3 | andy |
-------------------------------------------------------------------------[/FONT]

how can I select from BOOKS all fields if from table USERS db_verified = 1

something like:

select * from BOOKS where (USERS.db_verified = '1');

Thanks!

[unplugged]

$result = mysql_query("SELECT * FROM BOOKS WHERE USERS.db_verified = '1'");

while ($row = mysql_fetch_array($result) {
echo $row['db_title'];
}

ps i'm still a newbie but worth a shot.

[Lars_Berg]

select *
  from books
  where db_user in
  (select db_user
      from users
    where db_verified = 1)

[moraru]

thanks, it works perfectly!

thank you all!