I've been reading and reading on how to do joins, but it's all greek to me. Can someone tell me if this is something I can do with a join?
I have two tables:
stories
sid
uid
title
story
authors
uid
name
Now, normally, I would do two queries to get what I needed -- first one query to get the story data, then another query to get the author's name using the uid that is stored in the stories table. What I'd like to know is if there's a way to do all that in one query? Like I said, I've been fiddling around with join queries, but keep getting nasty error messages, and I'm not sure what I'm doing wrong. Can someone post a very simple join query that will do what I need, and I can build from there?
Basically, I want to print out the title, story, and name.
