I have a real stupid (propably) problem :)
I have two tables, one holding accounts:
CREATE TABLE accounts (
login varchar(32) primary key,
password varchar(32),
name varchar(128),
email varchar(64));
and one holding posts (to news system):
CREATE TABLE news (
author varchar(32) references accounts(login),
title varchar(32),
body text,
date timestamp default now(),
id serial);
...and I want using _one_ SQL SELECT get all news rows but with
accounts.name relation.
"SELECT name,title,body,date FROM accounts,news" doesn't work fine,
because it gets all rows from accounts table.
Thanks for help
John Moo