var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Looking up fields.
I have a table that holds record values as follows:
[Request ID], [Invoice Number]
An SQL statement "SELECT [Request ID] FROM [Requests] WHERE [Invoice Number]=3" gives the display above. I'm trying concatenate those [Request ID]s to show as follows:
[Invoce Number] [Request ID]
3 12, 21
Can this be done in a single SQL statement? Thanks.
I won't byte... hard!
That would be a crosstab.