[prog] SQL Joins

[Cynthia Kiser]

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

-- 
Cynthia N. Kiser
cnk at ugcs.caltech.edu