Sql query on joins

Question

Hi,

I have 15 tables in my database and all tables has common column called "CustomerName".

I want to retrive the data from 15 tables where customerName ='XYZ'.

I tried this one:

select *
from Table1, Table2.....Table15
where CustomerName='XYZ';


Darma