SQL Statement Help Please

LauraQ · 08-05-2008, 09:33 AM

Hi all, I am creating a MySQL database and creating the database based around a DVD Company and just wondering if anyone could help me out with a little SQL statement problem I have (First time using MySQL).

I want to identify all DVDs that have scratch mark fault on them as well as the name of staff who wrote the fault report

I created a table for the fault report table which is:

FaultReport
StaffName
DateChecked
FaultFound
TypeofFault
DVDName

If anyone could help me out with this would be much appreciated.

Thanks.

**jamiemac2005** · 08-05-2008, 02:17 PM

Hey LauraQ,

As you haven't posted the values you use within the database i can only give you an idea of what the query should look like but:

Code:

SELECT DVDName, StaffName FROM FaultReport WHERE TypeOfFault="scratch";

(notes)
DVDName and StaffName would be displayed
Type of fault would not but you could modify this to display it

is what i think you'd be trying to use.

(of course scratch would be replaced with whatever notation you've used for a scratch mark)...

What had you tried so far?
Where were you slipping up?

Cheers,
Jamey

LauraQ · 08-07-2008, 10:16 AM

Thats awesome thanks a lot for the help, much appreciated! From what you helped me with I tried to do a statement to product a list of job titles and salaries for all the staff working at the DVD company who began working after the 12th Of December 2001.. Not to sure how good the statement is though

Select JobTitle, Salary FROM StaffInformation WHERE DateJoinedCompany > 12/12/2001

From table:

StaffData
StaffID
Name
HomeAddress
Home Phone Number
DOB
Date Joined Company
Job Title
Salary

**jamiemac2005** · 08-07-2008, 10:19 AM

Hmm, it looks fine to me, (but i'm quite a noob mysql wise)...

Cheers,
Jamey

08-05-2008, 09:33 AM	#1 (permalink)
LauraQ Registered User Join Date: Aug 2008 Posts: 2 OS: XP	SQL Statement Help Please Hi all, I am creating a MySQL database and creating the database based around a DVD Company and just wondering if anyone could help me out with a little SQL statement problem I have (First time using MySQL). I want to identify all DVDs that have scratch mark fault on them as well as the name of staff who wrote the fault report I created a table for the fault report table which is: FaultReport StaffName DateChecked FaultFound TypeofFault DVDName If anyone could help me out with this would be much appreciated. Thanks.

08-05-2008, 02:17 PM	#2 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,878 OS: Vista, various linux distros	Re: SQL Statement Help Please Hey LauraQ, As you haven't posted the values you use within the database i can only give you an idea of what the query should look like but: Code: SELECT DVDName, StaffName FROM FaultReport WHERE TypeOfFault="scratch"; (notes) DVDName and StaffName would be displayed Type of fault would not but you could modify this to display it is what i think you'd be trying to use. (of course scratch would be replaced with whatever notation you've used for a scratch mark)... What had you tried so far? Where were you slipping up? Cheers, Jamey __________________ Myspace

08-07-2008, 10:16 AM	#3 (permalink)
LauraQ Registered User Join Date: Aug 2008 Posts: 2 OS: XP	Re: SQL Statement Help Please Thats awesome thanks a lot for the help, much appreciated! From what you helped me with I tried to do a statement to product a list of job titles and salaries for all the staff working at the DVD company who began working after the 12th Of December 2001.. Not to sure how good the statement is though Select JobTitle, Salary FROM StaffInformation WHERE DateJoinedCompany > 12/12/2001 From table: StaffData StaffID Name HomeAddress Home Phone Number DOB Date Joined Company Job Title Salary

08-07-2008, 10:19 AM	#4 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,878 OS: Vista, various linux distros	Re: SQL Statement Help Please Hmm, it looks fine to me, (but i'm quite a noob mysql wise)... Cheers, Jamey __________________ Myspace