On Monday 21 May 2012, Jan Bakuwel wrote:
> Hi,
>
> I'm trying to get my head around the following question. As an
> example take a table with products:
>
> productid (pk)
> name
>
> and productprice
>
> productpriceid (pk)
> productid (fk)
> pricedate
> price
>
> There are multiple records in
Hi,
I'm trying to get my head around the following question. As an example
take a table with products:
productid (pk)
name
and productprice
productpriceid (pk)
productid (fk)
pricedate
price
There are multiple records in productprice for each product as prices
(often) go up and (less often) go
Am 20.05.2012 05:04, schrieb Jasen Betts:
On 2012-05-19, Andreas wrote:
Hi,
I'm trying to fight against double entries in tables.
I got as far as I can find similar records with trigram string matching.
If I do this with a table compared to itself I get something like this:
id_a, id_b
3, 5
