SELECT docacmds.*, dctacmds.* FROM docacmds, dctacmds WHERE docacmds.DocDctKey = dctacmds.DctKey AND dctacmds.dctcat = 'C' AND docacmds.docnumber = 'ADL66609'Which has worked in ODBC to an Access table to find all the document numbers that start with 'ADL66609' but for some reason the command fails to find any records when the ODBC to pointing to a VFP Table.
SELECT docacmds.*, dctacmds.* FROM docacmds, dctacmds WHERE docacmds.DocDctKey = dctacmds.DctKey AND dctacmds.dctcat = 'C' AND docacmds.docnumber LIKE 'ADL66609%'All is fine. Why does ACCESS work like I expect, but not the FoxPro SQL?