subject:"column aliases in query"

Re: column aliases in query

2012-10-11 Thread hsv

2012/10/11 13:46 -0400, Mark Haney I know it's been a while since I wrote serious queries, but I'm sure I have done something like this before: SELECT SUBSTR(date,1,10) as vDate, event_id, events.mach_id, machine.factory_id FROM events JOIN machine ON events.mach_id = machine.mach_id W

RE: column aliases in query

2012-10-11 Thread Rick James

-Original Message- > From: Mark Haney [mailto:ma...@abemblem.com] > Sent: Thursday, October 11, 2012 10:47 AM > To: MySQL > Subject: column aliases in query > > I know it's been a while since I wrote serious queries, but I'm sure I > have done something l

column aliases in query

2012-10-11 Thread Mark Haney

I know it's been a while since I wrote serious queries, but I'm sure I have done something like this before: SELECT SUBSTR(date,1,10) as vDate, event_id, events.mach_id, machine.factory_id FROM events JOIN machine ON events.mach_id = machine.mach_id WHERE machine.factory_id = "1" AND vDate = "