Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2006

    Unanswered: sql query to create view


    I have one table called comments that looks like this

    recordno lineno comment
    100 1 Joe Smith
    100 2 Room 408

    I cannot modify this table but would like to create a view which looks like this:

    recordno guestname roomno
    100 Joe Smith Room 408

    Does anyone know how to write a SQL Query for This ?
    Last edited by cmack; 08-06-06 at 03:06.

Posting Permissions

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