SQL command required

My SQL already removes duplicates and some rows that are blank
with this:
Select * From itran INNER JOIN ihead ON itran.it_doc = ihead.ih_doc WHERE
itran.it_status = 'A' AND ihead.ih_quotat = "" AND itran.it_stock <>""

But I would like it to add a column from the data queried, that takes 2 of
the columns and multiplys them together
thanks
--
Vass

SELECT *, [ColumnX]*[ColumnY] AS [FieldnameZ] FROM .. etc.


Bas Hartkamp.


"Vass" <[email protected]> schreef in bericht
news:[email protected]...
> My SQL already removes duplicates and some rows that are blank
> with this:
> Select * From itran INNER JOIN ihead ON itran.it_doc = ihead.ih_doc WHERE
> itran.it_status = 'A' AND ihead.ih_quotat = "" AND itran.it_stock <>""
>
> But I would like it to add a column from the data queried, that takes 2 of
> the columns and multiplys them together
> thanks
> --
> Vass
>
>