On Tue, 10 Jun 2008, Martin wrote:
Lucio
So the net effect is to produce a cartesian join where ALL results from
Query1 (are combined with) ALL results from Query2
In order to prevent cartesian join can you use a more narrowly defined
predicate such as what is defined at
(mysql 5.0.27 on SuSE Linux)
I recently thought to use UNIONs to allow me to concatenate vertically
some database tables with statements like this
create or replace view combo as
(select * from nov06) union
(select *,ra_corr as ra_cor2,dec_corr as dec_cor2 from jul07) union
(select