Hi guys,
I wonder if you could help.
I have a table with a foreign key (contains news posts, the foregin key is authorID), that points to a primary key (in the authors table, with authorname).
How do I formulate a query that will take the authorID from the newsposts table and turn it into the name from the authors table?
I *think* it might be somethign todo with JOIN but I'm not sure.
Thanks in advance,
Mike
I wonder if you could help.
I have a table with a foreign key (contains news posts, the foregin key is authorID), that points to a primary key (in the authors table, with authorname).
How do I formulate a query that will take the authorID from the newsposts table and turn it into the name from the authors table?
I *think* it might be somethign todo with JOIN but I'm not sure.
Thanks in advance,
Mike