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