Maik wrote:
>
> With "Union" you can create one view.
> Ciao Maik
UNION wouldn't have the desired effect:
the result of a UNION SELECT would look like this:
ID AMOUNT
1 (table1.amount)
2 (table1.amount)
. .
. .
1 (table2.amount)
2 (table2.amount)
What he wants is:
ID TABLE1.AMOUNT TABLE2.AMOUNT
1 (amount) (amount)
2 (amount) (amount)
. . .
. . .
You can achieve that result with an inner join (and even MySQL with it's
rather restricted SQL subset supports an inner join).
Nils
--
Alles van waarde is weerloos
Lucebert