SELECT * FROM Questions WHERE Type = 'Stupid'

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > SELECT * FROM Questions WHERE Type = 'Stupid'

Gumbercules: Jan 12, 2004; These aren't my lamps. These have feet.

MORE CURLY FRIES posted:

I want a page which gets the appointments for a given user today, and only if they have an appointment. I believe I can do a CREATE VIEW and then only pull rows that have staticApts.comment <> " " or something, but I'm not sure.

...

Is it possible to use the CREATE VIEW, and if so how would I join the tables?

So you want a view which represents every appointment today?

Could you just use a union here?

code:

CREATE VIEW appointments_today
AS
  (SELECT time,
          comment,
          details,
          clientId,
          StaffID
   FROM   staticApts
   WHERE  staticApts.day = DAY_NAME(CURRENT_TIMESTAMP)
   UNION 
   SELECT time,
          comment,
          details,
          clientId,
          StaffID
   FROM   dynamicApts
   WHERE  dynamicApts.date = DATE(CURRENT_TIMESTAMP))

SELECT * FROM appointments_today WHERE clientID = "bob"

It seems like that could get you what you want.

# ¿ Mar 2, 2008 23:36

Adbot: ADBOT LOVES YOU

# ¿ May 16, 2024 11:31

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > SELECT * FROM Questions WHERE Type = 'Stupid'