NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Old Version 11

changes.mady.by.user Unknown User (wileyal)

Saved on

compared with

New Version 12

changes.mady.by.user Unknown User (wileyal)

Saved on

Key

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

...

Code

Name

C01234

Heart

C98765

Heart Attack

Table Qualifiers

Code

Qualifier

C01234

isAnOrgan

C98765

isADisease

...

Code Block
SELECT * FROM Codes

</source>

Results in:

Code

Name

C01234

Heart

C98765

Heart Attack

...

Given two database tables, retrieve the Code, Name, and Qualifier for each Code.

Table Codes

Code

Name

C01234

Heart

C98765

Heart Attack

Table Qualifiers

Code

Qualifier

C01234

isAnOrgan

C98765

isADisease

...

Code Block
SELECT * FROM Codes JOIN Qualifiers ON Code

</source>

Results in:

Code

Name

Qualifier

C01234

Heart

isAnOrgan

C98765

Heart Attack

isADisease

...