Re: executing an SQL statement

[Lois Kim]

Randy,

I was wondering if it's possible to put two SELECT statement in $dbh->prepare() so that I can separate my queries for each tables, something like....

$dbh->prepare ("SELECT RPAD(myfield1,10,' ') FROM Table1 WHERE ....".
"SELECT RPAD(myfield2,10,' ') FROM Table2 WHERE ....")

I've tried and it was not working.
Is there any other way?

Lois K.