如何从嵌套在nodejs中具有多个表数据的json构建sql连接查询?

0vvn1miw  于 2021-09-23  发布在  Java
关注(0)|答案(0)|浏览(310)

如何从nodejs中嵌套了多个表数据的json构建sql连接查询?
添加输入和输出的示例代码片段。

  1. {
  2. filters:[
  3. {
  4. table: table1,
  5. field: some_field,
  6. operation: some_operation_like_equalto
  7. value: some_value_to_equat_to_field
  8. },
  9. {
  10. table: table2,
  11. field: some_field,
  12. operation: some_operation_like_equalto
  13. value: some_value_to_equat_to_field
  14. }
  15. ],
  16. fields:[
  17. {
  18. table: table1,
  19. field: some_field
  20. },
  21. {
  22. table: table2,
  23. field: some_field
  24. }
  25. ]
  26. }
  27. select A.some_field,B.some_field
  28. from (
  29. select some_field1 , field1 from table1
  30. ) as A
  31. GLOBAL FULL OUTER JOIN (
  32. select some_field1 , field1 from table2
  33. ) as B
  34. ON (A.field1 = B.field2)

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题