Welcome to WebmasterWorld Guest from 54.160.131.144

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

select from multiple tables - same field name

php/mysql

     

knighty

2:35 pm on Jan 10, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I have a number of tables ie, sales, number of customers, refunds.

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

TIA

dingman

3:14 pm on Jan 10, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Are you looking for something like "select S.january, C.january, etc from Sales as S [some kind of] join Customers as C [using field] where storeid=1234"?

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.

knighty

3:29 pm on Jan 10, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I don't know I just want to end up with ...

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?