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
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