General information
Category:
Coding, syntax & commands
When I try to create a query in the designer I get an error when I try to save the query.
The query runs fine, but it wont let me save it:
"query parse error-try rebuilding in query wizard or by using view designer join tab"
It always happen when I add the fourth table.
SELECT Tproduct.fpname, Ttooltype.fttype, Tvendor.fvname;
FROM dbtwiz!tproduct INNER JOIN dbtwiz!ttool;
INNER JOIN dbtwiz!ttooltype;
INNER JOIN dbtwiz!tvendor ;
ON Tvendor.fvnum = Ttool.fvnum ;
ON Ttooltype.ftnum = Ttool.ftnum ;
ON Tproduct.fpnum = Ttool.fpnum
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only