开发者

Cross-document link in Torrot table

开发者 https://www.devze.com 2022-12-07 19:00 出处:网络
I want to pull the torrot table with select tor_cat = TU documentation, same select tor_cat = FO documentation, is there a link between the two?

I want to pull the torrot table with select tor_cat = TU documentation, same select tor_cat = FO documentation, is there a link between the two?

SELECT 
  tu_tor~db_key,
  tu_tor~tor_id,
  tu_tor~tor_cat,
  tu_tor~purch_org_id,
  tu_tor~zex_rlt_erp开发者_StackOverflow社区_ord_no,
  src_stop~log_locid,
  src_stop~stop_cat,
  src_stop~stop_role
  FROM /scmtms/d_torrot AS tu_tor 
  INNER JOIN /scmtms/d_torstp AS src_stop ON tu_tor~db_key EQ src_torstp~parent_key
    AND src_torstp~stop_seq_pos = @/scmtms/if_tor_const=>sc_stop_seq_pos-pos_source_stop
  INNER JOIN /scmtms/d_torrot AS fo_tor ON 
  

ı dont know what ı will write the code after ON. ?

0

精彩评论

暂无评论...
验证码 换一张
取 消