[prog] older mysql query

Wolf Rising wolfrising at gmail.com
Fri Dec 7 14:06:22 UTC 2007

I have the same query being used for two separate databases:

select distinct concat(l_name,', ', f_name) as name, ssn,
dent.s_code, concat(acctPrefix, '@', acctSuffix) as email
FROM ssc.accounts, ssc.term, ssc.dent WHERE
dent.status='AC' AND accounts.p_code = dent.s_code
AND dent.s_code= term.s_code
ORDER BY l_name, f_name

I have the same exact query for another database called ssa, is there
a way using join that I can merge these two queries together and run it
as one? the version of mysql is 3.2x so union isn't recognized.


More information about the Programming mailing list