Re: INTERVAL question



Yeah, it is complaining with ERROR 1604: You have an error in your SQL
syntax...

How to get the numbers without using subqueries?

Thanks!

.



Relevant Pages

  • Re: Strat - Shante shit...
    ... She rocked the house better than I'd have expected for someone who hasn't put out an album in, what, 15 years? ... Yeah, when it was her turn to take the stage, she just stood there at first, telling the soundboy about the monitor speakers being too loud. ... Eternia is on the same tour, but not on these two shows and Yarah Bravo left the tour a couple of days ago, complaining about a lack of respect or something. ...
    (rec.music.hip-hop)
  • Re: Create SELECT COUNT from given statement
    ... but I don't know that it supports derived table subqueries in the FROM clause like that. ... run a few sample queries using both the derived-table subquery method and the straight SELECT COUNT... ... the whole SQL and create a new counting statement or do todays DB-Engines a good job on optimizing this? ...
    (comp.databases)
  • Re: SQL Query Question: Avoiding Subqueries
    ... if your problem is the number of subqueries and joins, ... "Ken Dibble" schrieb im Newsbeitrag ... > possible SQL SELECT statements. ... >>> SQL Query Question: ...
    (microsoft.public.fox.programmer.exchange)
  • CBO Subquery Limitations
    ... Oracle 9.2.0.6 EE on Windows ... evaluating SQL with subqueries in 9i. ... It appears that it will Unnest subqueries whenever possibe without any ...
    (comp.databases.oracle.server)
  • Re: sorting a 3d array?
    ... Subqueries are almost never correct. ... the whole complicated query should be encapsulated as a subquery. ... But you can get a lot of help and explanation on how to structure your SQL statements in the appropriate newsgroup - such as comp.databases.mysql. ... This is a PHP newsgroup, in case you haven't noticed the name. ...
    (comp.lang.php)