I tried 'show me the planets where the aliens live'but it didn't work.
(
rob,
Wed 5 Mar 2003, 11:28,
archived)
got the syntax wrongtry
SELECT * FROM planets WHERE aliens_live = true;
(SELECT * FROM planets WHERE aliens_live = true;
munkt0n,
Wed 5 Mar 2003, 11:29,
archived)
AhaI see your mistake, it should have looked like this.
SELECT Sky.Where_The_Aliens_Live,
FROM Sky
GROUP BY Sky.Where_The_Aliens_Live,
HAVING (Sky.Do_Aliens_Live_Here=True);
(SELECT Sky.Where_The_Aliens_Live,
FROM Sky
GROUP BY Sky.Where_The_Aliens_Live,
HAVING (Sky.Do_Aliens_Live_Here=True);
GR33DY,
Wed 5 Mar 2003, 11:32,
archived)