Welcome to WebmasterWorld Guest from 220.127.116.11
each table is split up by months jan, feb, march etc.
I want to display all the months and then each table on a row, so along the top you have the months then below each month would be the appropiate figure from each table.
can i use something like select * from sales, customers where storeid=12345
then print out $jan, $feb, $March
I'm struggling on how to output the results cos there are going to be more than one field called january - how do get sales/january and customers/january
That's a very rough outline, but when you need to disambiguate filed names in a select on multiple tables, the 'as' keyword is your friend.
SALES JAN - 35%
SALES FEB - 50%
CUSTOMERS JAN - 456
CUSTOMERS FEB - 654
where sales and customers are the tables, Jan and feb are field names and numbers are the values of the fields.
I know I can just do
select * from sales where storeID=666
select * from custoers where storeID=666
but I have a lot of tables and wondered if I can do it all in one go?