select contact.create_man,contact.share_man,contact.account,contact.contact,action.action_content,action.acction_date from contact left join action on contact.account=action.account and contact.contact=action.contact 试试这个查询
SELECT c.create_man ,c.share_man ,c.account ,c.contact ,a.action_content ,a.action_date FROM [contact] c WITH(NOLOCK) LEFT JOIN [action] a WITH(NOLOCK) ON c.account = a.account AND c.contact = a.contact
from contact left join action on contact.account=action.account
and contact.contact=action.contact
试试这个查询
,c.share_man
,c.account
,c.contact
,a.action_content
,a.action_date
FROM [contact] c WITH(NOLOCK)
LEFT JOIN [action] a WITH(NOLOCK)
ON c.account = a.account AND c.contact = a.contact