hello my project is web discussion forum..i want to get some values of topic table and some values of user table.
in topic table have user id field how can i get user name againts user id.
user table have user id field thanks in advance ....
mani508
0
Newbie Poster
Recommended Answers
Jump to PostSELECT t.field1, t.field2, u.username FROM topic t INNER JOIN user u ON t.user_id = u.user_id;
Jump to PostThat's great mani508. Could you mark the thread solved? Thanks!
All 5 Replies
androtheos
6
Light Poster
SELECT t.field1, t.field2, u.username
FROM topic t
INNER JOIN user u
ON t.user_id = u.user_id;
mani508
0
Newbie Poster
ok thanks alot i got it.....
androtheos
6
Light Poster
That's great mani508. Could you mark the thread solved? Thanks!
mani508
0
Newbie Poster
how can i marked i m new i don't know??
androtheos
6
Light Poster
There should be a "Mark Question Solved" button at the bottom of the post.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.