MySQL Forums
Forum List  »  Newbie

MySQL Query Containing Multiple Queries
Posted by: Zack Silverman
Date: April 07, 2012 08:49PM

I have a database that holds some basic customer information "first_name", "last_name", "address", "city", "state", "zip", "year" and "make" information for an automotive repair shop.

I am having a few problems figuring out a MySQL query that will retrieve the following information from the appropriate tables.

* 2001-2009 Honda, Mitsubishi, Nissan, Toyota

The structure of the tables can be seen below.

Table "auto_db":
* first
* last
* address
* city
* state
* zip
* year
* make
* model


Any Help is Much Appreciated!
Thanks :)

Options: ReplyQuote


Subject
Written By
Posted
MySQL Query Containing Multiple Queries
April 07, 2012 08:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.