汇科天下
Page tree

Versions Compared

Old Version 5

changes.mady.by.user 张扬

Saved on

compared with

New Version 6

changes.mady.by.user 张扬

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
linenumberstrue
collapsetrue
SELECT bb.`lower_user_name`,bb.`user_key`,aa.`email_address`,aa.`display_name` FROM cwd_user aa,app_user bb
WHERE aa.`lower_user_name` = bb.`lower_user_name`


模块

Code Block
SELECT
	na.SOURCE_NODE_ID as "问题id",
	na.SINK_NODE_ID as "模块id",
	c.cname as "模块名称"
FROM
	nodeassociation na
	LEFT JOIN component c on na.SINK_NODE_ID=c.ID
WHERE
	SOURCE_NODE_ID = 10939 
	AND SINK_NODE_ENTITY = 'Component';