b3ta.com board
You are not logged in. Login or Signup
Home » Messageboard » XXX » Message 878440 (Thread)

# But
what would you ask it?
(I helped save b3ta! GR33DY, Wed 5 Mar 2003, 11:26, archived)
# Daddy or Chips ?
silly !
(I helped save b3ta! FlanFlinger 🥧, Wed 5 Mar 2003, 11:27, archived)
# you mean
select * from sky where ANSWER like 'daddy' or ANSWER like 'chips';
(I helped save b3ta! LP, Wed 5 Mar 2003, 11:32, archived)
# I tried "show me the planets where the aliens live"
but it didn't work.
(I helped save b3ta! rob, Wed 5 Mar 2003, 11:28, archived)
# got the syntax wrong
try

SELECT * FROM planets WHERE aliens_live = true;
(I helped save b3ta! munkt0n, Wed 5 Mar 2003, 11:29, archived)
# Aha
I 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);
(I helped save b3ta! GR33DY, Wed 5 Mar 2003, 11:32, archived)