Am trying to make a subquery, where the first query finds every entity with a specific first
Fantastic news! We've Found the answer you've been seeking!
Question:
Am trying to make a subquery, where the first query finds every entity with a specific first name, and then a subquery that limits said entities to a specific last name.
Here are the relevant table:
Create Table Customer ( Customer_id int NOT NULL AUTO_INCREMENT, FirstName VARCHAR(50), LastName VARCHAR(50), MailingAddress Varchar(50), ShippingAddress VARCHAR(50), PhoneNumber Varchar (50), CreditCardLimit VARCHAR(50), DiscountPossible boolean, DiscountAmount int, CONSTRAINT Customer_id_PK PRIMARY KEY (Customer_id) );
I'm not too sure on the syntax on how to write that query and subquery.
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: