Creating a view from multiple tables Options

[tudsy]

Hi

I have 4 tables, CustomersArt,Customers,subscribers and emailcomm.

My question is, how do i create a view from these 4 tables with the column email ?

I have done a view from one table (see below):

$query = "CREATE VIEW ecovib2d AS SELECT email FROM CustomersArt";


Any help will be appreciated.

[CharlesEF]

Telling me about an error but now showing the query doesn't help much. The query should look like this:

CODE

$sql = "(SELECT * FROM `Customers` WHERE `email` = '$email')
        UNION
        (SELECT * FROM `CustomersArt` WHERE `emailadd` = '$email')
        UNION
        (SELECT * FROM `emailcomm` WHERE `emailaddress` = '$email')
        UNION
        (SELECT * FROM `subscribers` WHERE `emailsub` = '$email')";

If you also need to know where each row comes from then the query can be change to show this.