Thread
:
JOIN two queries using the 1st query results?
View Single Post
06-04-2012, 11:55 AM
#
3
Dan
Status:
Request a custom title
Join date:
Feb 2005
Location:
Expertise:
Software:
Posts:
3,164
iTrader:
15
/ 86%
Yeah it's one table. Is this method better than actually joining the two tables?
Here's what I had:
SELECT * FROM `forum topics` t join `users` u on `u.id` = 't.author' WHERE `t.slug` = '{$slug}' ORDER BY `t.id` LIMIT 1
Dan
View Public Profile
Find More Posts by Dan