Query error in Access
Hello Everyone,
If I run the following query in MySQL Control Center or MySQL-Front it works
correctly,
SELECT -1 AS ProductID, "Add New Part" AS PartNumber, "" AS VendorPartNo, ""
AS Description, "" AS VendorStatus FROM Products UNIO
2004 02:09
An: [EMAIL PROTECTED]
Betreff: Query error in Access
Hello Everyone,
If I run the following query in MySQL Control Center or MySQL-Front it
works
correctly,
SELECT -1 AS ProductID, "Add New Part" AS PartNumber, "" AS
VendorPartNo, ""
AS Description, &qu
Hello Everyone,
If I run the following query in MySQL Control Center or MySQL-Front it
works correctly,
SELECT -1 AS ProductID, "Add New Part" AS PartNumber, "" AS
VendorPartNo, "" AS Description, "" AS VendorStatus
FROM Products
UNION SELECT ProductID, PartNumber, If(SubNo=1135,
VendorPart,A
