In connection with my earlier thread,I have tried the various codes given to me, but finding it hard to adapt to my situation. These things possibly take much more time than anticipated.Inspired by Mike Yearwood,I am also doing the following:
Creating two select statements, one for Dailywork, One for wages, and sending both outputs to cursors which will finally be merged in a final cursor. The first 2 selects are working fine. But the final merge into the cursor is not working, with the error message :"Command contains unrecognised phrase/keyword." This is at the line I have marked below,as '->'
My code is as follows:
SELECT Dailywork.ddate, Dailywork.copr, Dailywork.cgang,;
Dailywork.cblock, Dailywork.nmty, Dailywork.nmen, Dailywork.nwmn;
FROM guinty!dailywork;
ORDER BY Dailywork.ddate;
INTO CURSOR CursorWork

SELECT Gang.ddate, Gang.gcode, Gang.gname, Gang.nmty, Gang.nmen, Gang.nwmn,;
Gang.nadl;
FROM guinty!gang;
ORDER BY gcode,ddate;
INTO CURSOR CursorGang

Select Cursorwork.Ddate , Cursorgang.gname ;
-> FROM CursorWork INNERJOIN CursorGang ; && HERE LIES THE PROBLEM
ON CursorWork.ddate=CursorGang.ddate;
INTO cursor CursorWage

Could someone tell me what could be the reason?
Please note that I do not belong to the (underworld !!), and the table 'GANG' above refers to groups of people with different pay-scales.

THANKS,

Regards,

Steve