in reply to Re: Re: Re: Re: Maximum DBI query length?
in thread Maximum DBI query length?

nope, you need to list out each of the tables..
SELECT contact.field1, contact.field2, business.field1, acn.field1 FROM contact, business, acn WHERE ... (Etc.)
or you can assign aliases
SELECT c.field1, c.field2, b.field1, a.field1 FROM contact c, business b, acn a WHERE ... (Etc.)

OK?

Replies are listed 'Best First'.
Re: (boo) RE5 Maximum DBI query length?
by Merlin83 (Novice) on May 07, 2001 at 22:01 UTC
    Fantastic, thanks. I've had to take out the AS thing, since I don't know where in the statement it goes, but I'm back to a working script that doesn't produce any results.

    Thanks again.