Posted by Oli Filth on 11/04/80 11:31
bizt said the following on 07/11/2005 11:24:
>
> I would like to select all the rows from both tables in a single SELECT
> statement so when I output them they will be integrated. This is not
> the same as a table join as their are no keys and I want the rows from
> both to remain seperate. Can this be done? Could someone please post an
> example SQL statement demonstrating this if so?
>
UNION
--
Oli
Navigation:
[Reply to this message]
|