How to write this SQL statement in Active Record

[eluser]WanWizard[/eluser]
Read the query, and then read it again. There is no join in this query. If you don't see the error, may I suggest to read up on designing queries?

Code:

mysql> use test;
Database changed

mysql> select * from users;
+---------+----+--------+
| user_id | id | name   |
+---------+----+--------+
|       1 |  1 | user 1 |
|       2 |  2 | user 2 |
+---------+----+--------+
2 rows in set (0.00 sec)

mysql> select * from example_tbl;
+---------+--------+
| slogan  | brief  |
+---------+--------+
| slogan1 | brief1 |
| slogan2 | brief2 |
+---------+--------+
2 rows in set (0.00 sec)

mysql> SELECT a.slogan, a.brief, u.id, u.name FROM example_tbl AS a, users AS u WHERE u.user_id =1;
+---------+--------+----+--------+
| slogan  | brief  | id | name   |
+---------+--------+----+--------+
| slogan1 | brief1 |  1 | user 1 |
| slogan2 | brief2 |  1 | user 1 |
+---------+--------+----+--------+
2 rows in set (0.00 sec)

Urhm... I really see 2 rows in the result set here...