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
Opal | Level 21

Where does SAS come into this?

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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