Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Unanswered: Sqlstate = 428c4

    Hie,
    I got this error (SQLSTATE = 428C4) when submitting this SQL statement..
    What should I do then?
    TQVM

    Select catalogentry_oid, title from lwplms.catalogentry_text where catalogentry_oid in (select catalogentry_oid, count(*) from lwplms.enrollment where enrolldate >= 2009-07-01-00.00.00 and enrolldate <= 2009-07-31-00.00.00 group by catalogentry_oid)

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    Quote Originally Posted by mareldlina
    catalogentry_oid in (select catalogentry_oid, count(*)
    what is count(*) doing here ?
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

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