On Aug 29, 3:11 am, pie...@hogranch.com (John R Pierce) wrote:
> On 08/28/11 3:13 AM, pe...@vanroose.be wrote:
>
> > First remark: that's an unusual table design: I would have expected the
> > pivoted form of Table2. Why? Well, every time a row is added to Table1
> > (DML),
> > a*column* has to b
On 08/28/11 3:13 AM, pe...@vanroose.be wrote:
First remark: that's an unusual table design: I would have expected the
pivoted form of Table2. Why? Well, every time a row is added to Table1 (DML),
a*column* has to be added to Table2 (DDL).
indeed, that was my initial reaction, it looked like a
Dear Eddie:
Regarding your two tables and the wanted result:
> Table 1 currency_acc
>
> +---
> IDNamecurrency+
> +---
> 23RAMSGD
> 32GOPGBP
> 45RANSGD
> 67KRI USD
> 78YUR
Dear Perl DBI users
I have two tables: currency_acc and amount_type. I would like to
extract Names from the first table who have SGD currency and keep as a
query for the second table
Table 1 currency_acc
+---
IDNamecurrency+
+-