var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.