Demo entry 6658308

_join

   

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

SELECT Awards.Awards.PK_AWARDS,
       sbir.submission.SUBMISSION_ID,
       Awards.Awards.top_no,
       sbir.submission.TOPIC_NUMBER,
       Awards.Awards.PI_NAME,
       sbir.submission.PM_NAME,
       Awards.Awards.PI_EMAIL,
       sbir.submission.PM_EMAIL,
       Awards.Awards.CO_NAME,
       sbir.submission.CO_NAME AS CO_NAME_SUB,
       Awards.Awards.CO_EMAIL,
       sbir.submission.CO_EMAIL AS CO_EMAIL_SUB,
       Awards.Awards.KEYWORDS,
       sbir.submission.PI_KEYWORDS,
       Awards.Awards.WholeAbstract,
       sbir.submission.PI_TECHNICAL_ABSTRACT,
       Awards.Awards.ANTICIPATED_BENEFITS,
       sbir.submission.PI_BENEFIT
FROM sbir.award
INNER JOIN sbir.submission
 ON sbir.submission.SUBMISSION_TITLE = Awards.Awards.PRO_TITLE;

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).