TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Amudhan Kuppan
NA
378
29.8k
Inner joins in sql
May 8 2018 7:36 AM
hi
i have one doubt please help me
create table Patient(
ID int not null primary key,
FirstName varchar(30),
LastName varchar(30),
DateOfBirth datetime
);
Create table Insurance(
ID int not null Primary key,
InsuranceName varchar(50),
);
Create table PatientInsurance(
PatientID int not null,
InsuranceID int not null,
Foreign Key(PatientID) References patient(ID),
Foreign Key(InsuranceID) References Insurance(ID)
);
there are three tables in my db and this is a table structure
iam insert a five record for each table ok
my question is : How to get a list of all patients having insurancename and patient does not have any insurance
how to prepare a script for this question please help me anyone
Reply
Answers (
6
)
Duplicate Records in my table
How to send email using trigger. When new Data is inserted?