Need some help to to realize the results in SQL.
Both input files are large, hope to get this done thru 1 time going loading the data.
Is this possible within SQL?
Is there a better solution, which is efficient?
Hi Nicolaij,
I'm not entirely sure what you want here. You talk about "input files", but that's not a term that has anything to do with queries. Do you mean entities? Do you have two entities with a large number of attributes, or are these entities that contain large binaries?
In any case, your SQL here doesn't make much sense, and isn't valid SQL anyway. Also, you always need an in1 record, the in2 record being optional. So you can never have a situation where in1 is not present, but in2 is. Is that the correct way for your data model?
Are the in1 and in2 entities compatible, i.e. do they have the same attributes? If so, you can select either the attributes from in1 or in2 in the SELECT, and have a common structure output.
The best solution very much depends on your data model, but since you haven't shown it, it's difficult to give you good advice.