DISTINCTROW across 2 tables?

[shadedecho]

OK, I want to construct a SQL query that returns a result set of unique pairs of 2 fields:

table A: table B:

x y x y
___ ___ ___ ___
3 4 4 5
4 5 4 6
3 6 3 4
4 5

the result set would do a DISTINCTROW across both tables, giving me something like

x y
___ ___
3 4
4 5
3 6
4 6


Help! (If it helps, I am using MySQL 3.23, and I'd like to not have to do anything like SELECT'ing into temp tables or anything like that)... anyone know how I can accomplish this?

 

[fluteplr]

Assuming mysql supports unions the query would be

select distinct x, y from tablea
union
select distinct x, y from tableb

 

[swampBoogie]

Mysql 3.23 does not support union so there is no other solution than using temporary tables.

 

[fluteplr]

Well I guess then you could get a real DBMS that actually supports a reasonable subset of Ansii SQL.

 

[tlbroadbent]

Check the following link for a method to emulate UNION queries in MySQL 3.x.

Writing UNION Statements in MySQL 3.x

http://www.nstep.net/~mpbailey/programming/tutorials.union.php

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[r937]

terry, you beat me to it

i was going to suggest the same tutorial, only at

Writing UNION statements in MySQL 3.x

http://codewalkers.com/tutorials.php?show=33

rudy