On Mon, Aug 25, 2003 at 07:10:02PM -0400, Dan Jones wrote:
> On Thu, 2003-08-21 at 20:21, Taylor Sittler wrote:
> > Is there any way to update table values based on values in another table?
> >
> > For instance, given:
> >
> > Table 1 (jobid, jobname)
> > Table 2 (person, jobid, jobname)
> >
> >
On Thu, 2003-08-21 at 20:21, Taylor Sittler wrote:
> Is there any way to update table values based on values in another table?
>
> For instance, given:
>
> Table 1 (jobid, jobname)
> Table 2 (person, jobid, jobname)
>
> could I update Table 2, setting jobname=Table1.jobname where
> Table1.jobid
Is there any way to update table values based on values in another table?
For instance, given:
Table 1 (jobid, jobname)
Table 2 (person, jobid, jobname)
could I update Table 2, setting jobname=Table1.jobname where
Table1.jobid=Table.jobid? Is it possible to do this in one SQL command,
so that
Fabrizio Tivano <[EMAIL PROTECTED]> wrote:
>
> i have 2 table :tbl1 and tbl2
>
> i need to make an update on tbl1 based from tbl2 records.
>
> Ex:
> update tbl1, tbl2 set tbl1.conf='1' where tbl2.name='AD' and tbl2.date=tbl1.date;
>
> mysql: MySQL 3.23.54
>
>
> i see this kind of query works
Hello dear all,
i have 2 table :tbl1 and tbl2
i need to make an update on tbl1 based from tbl2 records.
Ex:
update tbl1, tbl2 set tbl1.conf='1' where tbl2.name='AD' and tbl2.date=tbl1.date;
mysql: MySQL 3.23.54
i see this kind of query works on mysql 4.0.2
How i can do this with my version
