[Slide]

Another question, this time SQL related.

Imagine a table (data_table):

[ row_id ] [ string_id1 ] [ string_id 2]

and another table (string_table):

[ string_id ] [ string_value ]

I want to write a query that subsitutes both string_id fields with the string values but can only figure out how to do the first one, ie:

SELECT string_table.string_value AS string_val1 FROM data_table, string_table WHERE data_table.string_id1 = string_table.string_id AND data_table.row_id = x;

Any way to get the second string value without a second SQL query?