![]() Note, how the "special" case with "f1" = 50 stands out with the NULLs in F7 and F8. Up to here the code just reproduces your example and the SQL you posted. Insert into tab_b values (50, 500, NULL) // <- join case with f6 IS NULL 01:05:19.827 HXE HXE hxehost 00:18:01.659 853 DEVELOPMENTĬreate column table tab_a (f1 integer, f2 integer, f3 integer) Ĭreate column table tab_b (f4 integer, f5 integer, f6 integer) Ĭreate column table tab_c (f7 integer, f8 integer) Ĭreate column table tab_d (f9 integer, f10 integer, f11 integer) select current_timestamp, * from m_database ĬURRENT_TIMESTAMP SYSTEM_ID DATABASE_NAME HOST START_TIME VERSION USAGE For further questions, please make it easier for the folks who like to help you and do that yourself. ![]() This time I put in time and effort myself to provide a solution that (hopefully) does what you want. Without those, it's a lot more work for everyone to work through your requirements and see if the solution is working correctly. This would include CREATE TABLE statements for the tables and INSERT commands for the data. ![]() What's missing from your question is a minimal example to work against. I edited your question accordingly and added some formatting as well. In SAP HANA the term "dynamic join" is used very differently. ![]() The correct term for what you are looking for is "conditional join". ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |