/prog/ - SQL assistance

Name: Anonymous 2006-12-01 12:36

Working on a MySQL database for a newspaper so they can keep track of advertisers.

SELECT advertisers.name, advertisements.enddate, advertisements.startdate, advertisements.section, advertisements.description, advertisments.rate, advertisements.total, advertisements.archive, advertisements.comments, advertisements.size FROM advertisements, advertisers, addates, issues INNER JOIN addates ON issues.issue = addates.issue, INNER JOIN addates ON advertisements.archive = addates.archive, INNER JOIN advertisements ON advertisers.account = advertisements.account ORDER BY issues.date;

Returns not unique table/alias 'addates'. There are no fields in any table named 'addates'. Tried qualifying with dbname.table, and using `'s. Same error.

Name: Anonymous 2006-12-01 12:59

Try removing ", advertisers, addates, issues" from the query.

Name: Anonymous 2006-12-01 13:44

That produces a syntax error near 'INNER JOIN addates ON advertisements.archive = addates.archive, INNER JOIN adver' at line 1

Name: Anonymous 2006-12-01 14:07

>>3

It says "FROM advertisements INNER JOIN addates" now right?

Name: Anonymous 2006-12-01 14:09

Oh hang on, you need to remove those commas before the INNER JOINs

Name: Anonymous 2006-12-01 14:12

Try this:

SELECT

  advertisers.name,

  advertisements.enddate,

  advertisements.startdate,

  advertisements.section,

  advertisements.description,

  advertisments.rate,

  advertisements.total,

  advertisements.archive,

  advertisements.comments,

  advertisements.size

FROM advertisements

INNER JOIN addates

  ON addates.archive = advertisements.archive

INNER JOIN issues

  ON issues.issue = addates.issue

INNER JOIN advertisers

  ON advertisers.account = advertisements.account

ORDER BY issues.date

Name: Anonymous 2006-12-01 14:14

>>1

problems include
- you put all the tables you wanted to join in the from clause, effectively cross joining them
- you joined addates where you should have joined issues
- commas where not allowed

Name: Anonymous 2006-12-01 14:35

>>6
>>7
Thanks. I'll try that.

Name: Anonymous 2006-12-01 17:46

>>8

And did it work?

Name: Anonymous 2006-12-03 8:29

>>9
it's obvious he suffered a fiery accident after typing it in

Name: Anonymous 2009-01-14 13:42

I read SICP

Name: Anonymous 2011-02-04 11:44

Name: Anonymous 2011-02-04 13:30

Name: Sgt.Kabu耫焫kiman랑ᄗ 2012-05-28 21:10

Bringing /prog/ back to its people
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy

SQL assistance

1 Name: Anonymous 2006-12-01 12:36

2 Name: Anonymous 2006-12-01 12:59

3 Name: Anonymous 2006-12-01 13:44

4 Name: Anonymous 2006-12-01 14:07

5 Name: Anonymous 2006-12-01 14:09

6 Name: Anonymous 2006-12-01 14:12

7 Name: Anonymous 2006-12-01 14:14

8 Name: Anonymous 2006-12-01 14:35

9 Name: Anonymous 2006-12-01 17:46

10 Name: Anonymous 2006-12-03 8:29

11 Name: Anonymous 2009-01-14 13:42

14 Name: Anonymous 2011-02-04 11:44

15 Name: Anonymous 2011-02-04 13:30

16 Name: Sgt.Kabu耫焫kiman랑ᄗ 2012-05-28 21:10