Hi
I have two tables that I want to join together into a single, problem is they are unrelated to each other, this is to say that one file is transactions for a specific jobno so my code is:
select upper(cname) as name,type,desc,date,reason,operator,startfinish,transid,JOBNO from wipdata!logfile,operators into cursor tmplog readwrite where jobno=wipdata.jobno and operator=operators.nempno order by transid
The other file (PRODUCTIONLOG.DBF) is transactions not specific to a jobno but just to a daterange.
Both files have the same structure but obviously jobno is empty in the PRODUCTIONLOG.DBF
I'm struggling to work out what the syntax should be to join both tables together since I have no ON clause.
Any help extremley appreciated
Rob