Anyone good with SQL

[Sem]

Hello
anyone here good with SQL statements willing to help me out

 

[Sem]

Wrong section -see

http://forums.overclockers.co.uk/forumdisplay.php?f=41

its not really got anything to do with mysql or anything its oracle sql

but if its the wrong section could a mod please move

 

[Sem]

Ah got some friends at Uni doing an all nighter tonight on it, I'm ok with it but probably not that useful

maybe its the same uni as me as the deadline is tomorrow

 

[Sem]

SHU?

Had our walkthru on Tuesday - was happy with 79%

herts uni

the problem is the deadline is meant to be monday and i was hoping to do it over the weekend
but monday is a bank holiday and uni is closed meaning tomorrow is the last day i can actually hand it in

 

[Sem]

Whats the problem anyways?

i need to select certains values from different tables

heres what im using

SELECT value1,value2,value3 FROM table1, value4,value5, FROM table2, WHERE value6='value7'

it wont work it says

sql statement not properly ended

 

[Sem]

ive added WHERE cause the question asks you to limit the query to a certain value

brb trying something

 

[Sem]

woohoo solved it

for those that care

the problem was with the WHERE statement

i needed to prefix the column with the table name

and i had a comma somewhere it shouldnt have been

now only got 4 more questions to go

 

[Sem]

yet you aren't asking them?

[edit] just realised you probably meant for homework, ok well good luck with them. If needed help is always here

ever since i got the first question the rest seem to be falling into place

im flying through it now and only got 2 more questions
ill post if i have any more problems