BookmarkSubscribeRSS Feed
DbmsKOS
Calcite | Level 5
PRIMARY KEY VS FOREIGN KEYS SSMS (2019) EXPRESS

I have three tables at SQL SERVER 2019 described below:
Table DEPARTMENTS : Columns DeptID , DeptName example FINANCE, IT .
Table EMPLOYEE : Columns : employeeID , SupervisorID .
Table SUPERVISOR : Columns : FirstName, LastName, SupervisorID, DeptID .
HOW TO EXECUTE ON QUERY in SQL SYNTAX OF PRIMARY KEYS AND FOREIGN KEYS FOR THESE THREE TABLES???
THANK YOU DEAREST FRIENDS . YOUNG KOSOVAR CITIZEN FROM KOSOVO ..

0 rows affected how to fix it on INNER JOIN THREE TABLES To shown me example text Finance, HR ?
3 REPLIES 3
Patrick
Opal | Level 21

This looks like a study or interview question. To get you started: What are the relationships between the tables? What are the candidates for primary and foreign keys.

 

SASKiwi
PROC Star

Where does SAS come into this?

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1366 views
  • 0 likes
  • 4 in conversation