Re: Help with join

2004-02-10 Thread goran
try this select e.node_name,n.contact from events e , nodes n where ... - Original Message - From: "Lee, Gary D." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 09, 2004 7:19 PM Subject: Help with join Trying to create a select to give me the contact info for all nod

Re: Help with join

2004-02-09 Thread Jim Neal
Hi Gary, I'm not sure if your e-mail contains typos or not, but the first thing that I noticed is that you do not have a comma separating the selected fields i.e "select events.node_name, nodes.contact from events nodes where". If you do have the commas separating the selected fields plea