.film.id in (
select fs.star.film from fs.star where fs.star.last = 'Sheen'
);
(missing FROM)
DES
--
Dag-Erling Smørgrav - d...@des.no
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
on". This version uses the
primary (surrogage) key:
select distinct on (fs.film.id) fs.film.title, fs.film.year
from fs.film left join fs.star on fs.film.id = fs.star.film
where fs.star.last = 'Sheen';
DES
--
Dag-Erling Smørgrav - d...@des.no
--
Sent via pgsql-sql mailing list
where fs.star.last = 'Sheen'
group by fs.film.title, fs.film.year;
Is there a way to do this without the "group by" clause?
DES
--
Dag-Erling Smørgrav - d...@des.no
drop schema fs cascade;
create schema fs;
create table fs.film (
id serial not null primary key,
ti
