Patricia G. wrote:
> Hi Andy,
>
>
> Having a generic table with key value pairs like your current info
> table
> just leads to some really horrible SQL as you are currently finding.
>
>
>
> I agree with you .
>
> Unless you truly don't know what key-value pairs you are going t
Patricia wrote:
> Hi all,
>
> I'm having a hard time trying to create this query.
> I have two tables:
> log - columns: id, name and date
> info - columns: id, tag, value
>
> i.e.:
> log
> id | name | date
> -
> 1 | machine_name | 07/
Hi all,
I'm having a hard time trying to create this query.
I have two tables:
log - columns: id, name and date
info - columns: id, tag, value
i.e.:
log
id | name | date
-
1 | machine_name | 07/31/06
2 | another_machine_name | 08/01
