Combining SQL statements - 10-17-2003 , 08:17 AM
I have two sql statements that I would like to join into one statement
the first is
WHERE( node_data.contact = lower( 'email' ))
ORDER BY node_name
SELECT contact, report
WHERE( contact = lower( 'email' ))
I can't do a normal join since email may not be in the
Re: Combining SQL statements - 10-17-2003 , 03:34 PM
'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.
Re: Combining SQL statements - 10-17-2003 , 04:08 PM
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.)
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]