Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: doubt in this query

    Hello colleagues,
    someboady can explain me this query, i have doudt in t_hora and t_hora.hora.

    select * from t_hora left outer join SCHEMA.TABLE on t_hora.hora=time(INTERVAL_TO) and date(INTERVAL_TO)=date('15/07/2012') AND MEMBER='PART0' order by 1

    This table t_hora must be exist in the database?

    Best regards.
    DBA DB2 for LUW

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Yes.
    There should be a table named t_hora in the current schema and this table must have a field named hora
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    also, keep in mind since there is no WHERE clause on this table it will return every row from t_hora with or without data from schema.table when it matches the criteria in the ON clause.
    Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •