Demo entry 6658304

join

   

Submitted by carlo on Nov 06, 2017 at 18:09
Language: SQL. Code size: 841 Bytes.

SELECT awd.PK_AWARDS,                 
	      sub.SUBMISSION_ID,                 
	      awd.pro_no,                 
       	      sub.PROPOSAL_NUMBER,
	      awd.top_no,                 
	      sub.TOPIC_NUMBER,                 
	      awd.PI_NAME,                 
	      sub.PM_NAME,                 
	      awd.PI_EMAIL,                 
	      sub.PM_EMAIL,                  
	      awd.KEYWORDS,                 
	      sub.PI_KEYWORDS,                 
	      awd.WholeAbstract,                 
	      sub.PI_TECHNICAL_ABSTRACT,                 
	      awd.ANTICIPATED_BENEFITS,                 
	      sub.PI_BENEFIT            
FROM Awards.Awards awd            
INNER JOIN sbir.submission sub            
ON awd.pro_no = sub.PROPOSAL_NUMBER            
WHERE awd.PHASE = sub.SUBMISSION_TYPE;

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).