Set new variable name.

[whatsaname]

I've got two tables: one called issue and one called regionmail.
On table issue, i've got a collomn called SPARPROD. with only does have values
of "Products" or "SPARES.

On table regionmail, there are two collomns, one called "Products" and one
called "Spares", both collomns do have
different values.

I do need to get the value from Table Issue, collomn SPARPROD. ( this could
be either Products or Spares).
With should be placed in a new variable name( A none existing one of both
table quiries), with should call from table Regionmail , either the colloumn
Products or Spares.
( this depends on the value picked out of the collumn SPARPROD from table
issue)


Thanks in advanced

[yalta]

You did not specify the relationship between the tables, i.e. is there one
regionmail per sparprod? Anyway, you should try it with a UNION
That is, if products and spares are of the same type. I also assumed there is
a foreign key relationship between the tables:
************************************************** **********
select i.iid, products from issue i, regionmail r
where r.iid=i.iid
and i.SPARPROD = 'products'
union
select i.iid, spares from issue i, regionmail r
where r.iid=i.iid
and i.SPARPROD = 'spares'