I have two sql statements that I would like to join into one statement

the first is
SELECT node_data.node_name
FROM tsmadmin.node_data
WHERE( node_data.contact = lower( 'email' ))
ORDER BY node_name

the second
SELECT contact, report
FROM report_freq
WHERE( contact = lower( 'email' ))

I can't do a normal join since email may not be in the
report_freq table.

I wonder if someone finds out what exactly you want and what you mean by
'joining into one statement'.

I'd have said you need to look up the 'union' operator, but with your
last statement (about email not being in report_freq) makes me doubt
that's what you want.

If you expect someone to help you, you should give a little more effort
and reveal more details.

Rene


--
Rene Nyffenegger
http://www.adp-gmbh.ch

RebelScum wrote:
Your question seems to be mainly relevant to the mind readers amongst
us. Since I don't claim taht ability, I for one have no idea what you
might want to accomplish. Seems like the problem statement might use a
bit of a diagram to back it up.

If you can't use a 'normal' join, how about an 'abnormal' one? Variants
might include UNION, INTERSECT, left or right outer join, or
non-equijoin. Most text books include a decent description of these
variants. (If you mean 'values missing in one table but not the other',
then that might be a prelude to an outer join.)

--
/Hans
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]