Re: MySQL advanced select?
| From: | Andrew Etemadi | Date: | Fri, 08 Sep 2000 17:15:38 +0000 |
| Subject: | Re: MySQL advanced select? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-15911@lists.php.net to get a copy of this message | ||
>
>
> SELECT tUserEmail.email FROM tUserEmail LEFT JOIN tEmail ON tUserEmail.email=tEmail.email_copy
> where tEmail.email_copy IS NULL;
>
> I think...
>
> -robin
>
Or, you could try:
SELECT table1.emailFieldOfTable1, table2.emailFieldOfTable2 FROM table1, table2