darma teja

darma teja

  • NA
  • 493
  • 190k

Sql query on joins

Dec 10 2012 4:46 AM
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

Answers (3)