I have some tables loaded in my script, and I want to 'pre-calc' some data between two tables ... somehow I think the way I implemented this is not really efficient . . . is there another way to do such thing?
LEFT JOIN (CALLS_temp)
LOAD Serviceorders.Serviceordernr as Calls.Serviceordernr
LEFT JOIN (Calls)
,if(isnull([Calls.Serviceordernr]),'No SO', if(isnull(Serviceorders.Serviceordernr),'yes','no')) as [Calls.SOisRemoved]
DROP TABLE CALLS_temp;
some more explanation on the example above:
I have Calls and I have Serviceorders . . . Calls contain a serviceordernr ... but some serviceordernr's are nog available in de ServiceOrder table (removed).
Someone has suggestions how to do this more efficient??