CONSULTANT
C_ID C_LAST C_FIRST C_MI C_ADD C_CITY C_STATE C_ZIP C_PHONE C_EMAIL
100 Myers Mark F 10 Sky Blvd. Orlando FL 32825 4075551212 mm@xx.com
101 Hernandez Sheila R 33 Left Cr. Orlando FL 32811 4071115555 sh@yyx.com
102 ZHANG Brian 89 SE Ave. Tampa FL 32822 3211515555 bz@mm.org
103 Carlson Sarah J 22 NW Pl. Orlando FL 32825 4075111111 sc@uu.gov
104 Courtland Paul R 91 Water St. Orlando FL 32800 4075151155 pc@pp.net
105 Park Janet S 15 High Rd. Miami FL 32816 9541115555 jp@hr.net
PROJECT_CONSULTANTS
P_ID C_ID ROLL_ON_DATE ROLL_OFF_DATE TOTAL_HOURS
1 101 06/15/2008 12/15/2008 175
1 104 01/05/2008 12/15/2008 245
1 103 01/05/2008 06/05/2008 50
1 105 01/05/2008 12/15/2008 45
2 105 07/17/2008 09/17/2008 25
2 100 07/17/2008 09/17/2002 0
3 103 09/15/2008 03/15/2009 125
3 104 10/15/2008 12/15/2008 50
4 105 06/05/2008 06/05/2009 25
4 104 06/15/2008 12/15/2008 125
4 102 07/15/2008 12/15/2008 30
5 105 09/19/2008 03/19/2009 15
5 103 09/19/2008 03/19/2009 15
6 103 09/19/2008 03/19/2009 5
6 104 09/19/2008 03/19/2009 10
7 102 05/20/2008 12/20/2008 125
7 100 05/25/2008 12/20/2008 100
asked
Mar 26 '10 at 02:04 PM
in Default
Michael 4
9
●
9
●
9
●
9
Michael, could you at least accept some of the answers on your other questions - if you participate in this site, you are more likely to be helped. At the moment you just seem to be flooding us with badly formatted homework questions. Also please try and format your questions with the code format button.
Eventually people will stop helping you. Your questions will be closed, and possibly even your account will be deleted. If you show that you have learned, and that you want to participate here, then we will all show you respect.
Are these all homework questions? If so, I'd recommend no one help until a little bit of self-work is shown. Have you attempted to write this query and it didn't work? Let's see what you have.
The help that I will provide is formatting all your questions - as I have done your previous examples. There are several people here who would be welcome to stay in my house should they wish, and it irks me that they have to hurt their eyes looking at unformatted drek.
Would the Answer look like this Select C_Zip, Roll_Off_Date from Consultant, Project_Consultant where C_zip=Roll_off_date And C_zip=32825,32811,32822,32800,32816