Results 1 to 20 of 20

Thread: [RESOLVED] Eliminating multiple entrances in SQL query

Threaded View

  1. Jul 10th, 2006, 07:25 AM #1
    josephine
    josephine is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2006
    Location
    3rd rock from the sun
    Posts
    360

    Resolved [RESOLVED] Eliminating multiple entrances in SQL query

    ello all

    in a table i have multiple entrances.
    can i, via the SQL statement, make sure i have just 1 entry per B.serial?
    and that the above entry will have the latest B.date?
    SQL statement now:
    VB Code:
    1. "select B.serial, B.version, CONVERT(char(20), B.date,113) 'Date Started', C.name 'Status' from BLCodes C, Bootloader B WHERE B.status = C.code"

    tnx in advance for help on this.


    regards,
    Last edited by josephine; Jul 11th, 2006 at 09:05 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width