Re: SQL statement not working

2015-07-01 Thread Loon, EJ van (ITOPT3) - KLM
@VM.MARIST.EDU Subject: Re: SQL statement not working you’re missing the from clause of your sql statement. > Op 1 jul. 2015, om 09:49 heeft Loon, EJ van (ITOPT3) - KLM > het volgende geschreven: > > Hi guys! > I'm trying to select all ANE4987E messages for all nodes with the tex

Re: SQL statement not working

2015-07-01 Thread Remco Post
you’re missing the from clause of your sql statement. > Op 1 jul. 2015, om 09:49 heeft Loon, EJ van (ITOPT3) - KLM > het volgende geschreven: > > Hi guys! > I'm trying to select all ANE4987E messages for all nodes with the text > 'Component Team Windows' in the contact field. For some reason I

SQL statement not working

2015-07-01 Thread Loon, EJ van (ITOPT3) - KLM
Hi guys! I'm trying to select all ANE4987E messages for all nodes with the text 'Component Team Windows' in the contact field. For some reason I cannot get the SQL statement to work. What am I doing wrong? select actlog.date_time, actlog.nodename, actlog.message, nodes.node_name, nodes.contact