[EMAIL PROTECTED] wrote:
Merlin <[EMAIL PROTECTED]> wrote on 10/04/2005 10:58:21 AM:
> [EMAIL PROTECTED] wrote:
>
> >
> >
> > Merlin <[EMAIL PROTECTED]> wrote on 10/04/2005 10:21:00 AM:
> >
> > > Hi there,
> > >
> > > I just discovered, that I do have some old rows I do not need
> > anymore.
Merlin,
Ouch, brain cramp, make that...
SELECT id
FROM table1
LEFT JOIN table2 ON table1.id=table2.table1_id
WHERE table2.table1_id IS NULL;
PB
-
Merlin wrote:
Hi there,
I just discovered, that I do have some old rows I do not need anymore.
A result from forgeting to empty the table b
Merlin,
>I just discovered, that I do have some old rows I do not need anymore.
>A result from forgeting to empty the table before starting to go into
production :-)
>However, I do try to find the rows which are not asociated with
another table in
>order to delete them. I have 2 tables: table1
Merlin <[EMAIL PROTECTED]> wrote on 10/04/2005 10:58:21 AM:
> [EMAIL PROTECTED] wrote:
>
> >
> >
> > Merlin <[EMAIL PROTECTED]> wrote on 10/04/2005 10:21:00 AM:
> >
> > > Hi there,
> > >
> > > I just discovered, that I do have some old rows I do not need
> > anymore. A
> > > result from forgetin
Merlin <[EMAIL PROTECTED]> wrote on 10/04/2005 10:21:00 AM:
> Hi there,
>
> I just discovered, that I do have some old rows I do not need anymore. A
> result from forgeting to empty the table before starting to go into
> production :-)
> However, I do try to find the rows which are not asociat
