I am developing a database for a company and am relatively new at making something from nothign. The question that i have is that i have a "CustomerMaster" file which i upload to my database, then i have to join it with about 7-8 different files. The way i am doing this is I am joining it one by one by creating a view for example
" create view as
select * from a,b inner join on....."
and then using the created view to join to the next table.
so as you can see i am doing this one by one. With each additional join it is getting much more slower and slower.
is there anyway i can joing them all together at once, or is there any better way of doing this.
thanks
" create view as
select * from a,b inner join on....."
and then using the created view to join to the next table.
so as you can see i am doing this one by one. With each additional join it is getting much more slower and slower.
is there anyway i can joing them all together at once, or is there any better way of doing this.
thanks
