Look into select into or just insert. The mysql doc covering this might even
have a suitable example.
On Jul 23, 2011 8:42 AM, "Velen Vydelingum" wrote:
> Hi,
>
> I have 2 tables and need to create a 3rd one as follows:
>
> Table Sales:
> Code Price sQty sDate
> 123 12.00 2 2011-03-12
> 190 10.00
Hi,
I have 2 tables and need to create a 3rd one as follows:
Table Sales:
Code Price sQtysDate
12312.0022011-03-12
19010.0012011-03-14
12313.0022011-03-29
12313.0032011-03-31
19011.0022011-03-31
Table Costs
