Hi, I have some troubles with select from multiple tables. There are 3 tables - books (id, name), borrow_log(id_book, id_user), users(id, name). All i want to do is select books that havent been borrowed by specific user (e.g. "John"). I wonder if it could be done w/o subqueries?
Thanks in advance.

look at the various permutations of the join construct
MySQL :: MySQL 5.0 Reference Manual :: 12.2.8.1 JOIN Syntax

I went through it many times, but i cant get it to work. I have this query:

select * from book as b
left join borrow_log as bl on b.id = bl.id_book
left join users as u on u.id_users = cl.id_user
where u.nick <> "John"

but i dont know what to do so as it do not return books that John's already borrowed - there are still rows with the same book id but different user

Not sure if its gonna work but you can try this.

SELECT users.name, books.name
FROM users,books.borrow_log
WHERE books.id=borrow_log.id=users.id