B
Brian
I have a union query that is quite simple:
SELECT DetailCust.OrderNumber,
Mid(DetailCust.ProductCode,3,2)+MID(DetailCust.ProductCode,7,2) AS Expr1,
DetailCust.Quantity, DetailCust.UnitPrice, DetailCust.ExtendedPrice
FROM DetailCust
WHERE (((DetailCust.ProductCode) Like "tbjm*"));
UNION
SELECT DetailCust.OrderNumber,
Left(DetailCust.ProductCode,2)+MID(DetailCust.ProductCode,5,2) AS Expr1,
DetailCust.Quantity, DetailCust.UnitPrice, DetailCust.ExtendedPrice
FROM DetailCust
WHERE (((DetailCust.ProductCode) Like "tbjm*"));
The query runs great an I get the data I am expecting. How do I save it in
the table, or do I have to add it to another table?
Brian
SELECT DetailCust.OrderNumber,
Mid(DetailCust.ProductCode,3,2)+MID(DetailCust.ProductCode,7,2) AS Expr1,
DetailCust.Quantity, DetailCust.UnitPrice, DetailCust.ExtendedPrice
FROM DetailCust
WHERE (((DetailCust.ProductCode) Like "tbjm*"));
UNION
SELECT DetailCust.OrderNumber,
Left(DetailCust.ProductCode,2)+MID(DetailCust.ProductCode,5,2) AS Expr1,
DetailCust.Quantity, DetailCust.UnitPrice, DetailCust.ExtendedPrice
FROM DetailCust
WHERE (((DetailCust.ProductCode) Like "tbjm*"));
The query runs great an I get the data I am expecting. How do I save it in
the table, or do I have to add it to another table?
Brian