Anyone good with SQL

[Sem]

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

 

[Morba]

there is a forum a few up from here that might interest you

 

[MR_Punk]

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

 

[AGD]

Wrong section -see

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

 

[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

 

[Vanilla]

I can help you with back end layout

 

[MR_Punk]

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

SHU?

Had our walkthru on Tuesday - was happy with 79%

 

[Van Hellseek]

Wrong section -see

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

Yes, but he's not likely to get much of a response there at this time of night is he?

Better to post it here for us nocturnal types and let a mod move it in the morning/later.

 

[MR_Punk]

Which mod is doing the night shift tonight?

 

[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

 

[MR_Punk]

Whats the problem anyways?

 

[Anim]

Select * from OcUKUsers
Where OcUKUsers.SQLKnowledge > 0 and OcUKUsers.Sleeping <> True


evidently there will be no records found

 

[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

 

[unwashed potato!]

cos you need to say value1 from table1, then value 2 from table 2 etc but not in those words, will find out.

this should have gone in the correct area as i was there and didn't see it and it was only by chance i came here and it caught my eye

 

[unwashed potato!]

google would have given you this answer quickly if what i read you want is correct, keywords being 'select multiple table mysql'.

here you go

SELECT employees.Firstname, employees.Lastname, crew.experience FROM 
employees, crew;

let me know it works so i can go to bed

 

[Pho]

SELECT t1.value1,t1.value2,t1.value3, t2.value1,t2.value2,t2.value3 FROM table1 t1, table2 t2 ?

edit, beat

 

[Vonhelmet]

SELECT table1.value1, table1.value2, table1.value3, table2.value4, table2.value5 FROM table1, table2 WHERE tableX.value6='Y';

Not sure how your where bit works, depends what you're trying to achieve.

I really think this would be better done with a proper JOIN...

 

[Cambofrog]

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

Among other things, the comma between table2 and WHERE could be screwing things up.

 

[Sem]

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

brb trying something