[prog] SQL Joins

Cynthia Kiser cnk at ugcs.caltech.edu
Wed Apr 14 09:08:27 EST 2004

Not sure if mysql has subqueries now. If not, amend the "off contract"
query in my previous post to:
	select **stuff you want**
	from **tables using your outer joins**
	where contract price is null

And if mysql supports UNION ALL, that might give you better
performance merging the two sets - since you know they are mutually

Cynthia N. Kiser
cnk at ugcs.caltech.edu

More information about the Programming mailing list