How can I write a query that answers the following question: Which stores
have not entered soups in the collection_schedule for the current day? I
just want to get a list that shows the stores.code, stores.name,
stores.phone of all the stores that failed to update the soups for the day.
collect
Where is a good place to find help with some basic sql? I am having a
problem getting the query results I need. Don't tell me to consult the
manual because that is the first place I turned to. I just need a real life
example of the solution to see be able to pick it apart. I posted the
request
Hi!
This query works: select date_format(date, "%W, %e %M %Y") as date from
table
This query doesn't: select concat(date_format(date, "%W, %e %M %Y"),"
",another) as time_of_day
I'm wondering if it is possible to use concat in this way and how if it is
possible.
Thanks!
Jeff
I realize this may be a little OT but I'm sure many of us MySQL rookies
would be interested in the responses.
I would be interested in hearing how someone goes about planning the layout
of their database including how they determine what tables, fields, column
types, queries, etc they will need.
