Query to get data from a main table
- by Thu Thuy
I have an Information table with 3 colums tableName/FieldName/Value and its data like this:
TableName|FieldName | Value
Films |DateSortie |NULL
Films |Duree |NULL
Films |CodeLangue |NULL
Films |Documentaire |NULL
Could you show me a SQL statement to put data into the Value Field, please! Note that I also have table Films and its fields like data in FieldName field of the Information table
Thanks in advance
TNT