Anyone good with SQL

Cambofrog · 2 May 2008 at 00:46

We need more info regarding your database schema, regarding your tables, fields and their relationships and data types for the fields.

Also, give meaningful names to your tables and their fields.

HTH.

Sem · 2 May 2008 at 00:49

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

Cambofrog · 2 May 2008 at 00:54

Sem said:
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

Nice one mate, keep going

unwashed potato! · 2 May 2008 at 00:55

Sem said:
now only got 4 more questions to go

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

Sem · 2 May 2008 at 01:29

Mammalian said:
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