Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- join question
April 20, 2009, 9:18 am
rate this thread
Now I want to display creation_user and modification_user at the same time
with one query.
Is it possible?
to join the two table can be done like this
select * from topic t join user u on t.creation_user_id = u.id and
t.modification_user_id = u.id
but I want to display the username for both of cration_user and
name creation_user modification_user
Topic1 user1 user2
Re: join question
Wrong newsgroup. ;-)
PHP != Database
PHP !== Database
"There are two ways of constructing a software design: One way is to
make it so simple that there are obviously no deficiencies, and the
other way is to make it so complicated that there are no obvious
deficiencies. The first method is far more difficult."
-- C.A.R. Hoare
- The Natural Philosopher
April 20, 2009, 1:18 pm