Query Help

[ismael_lopez]

Hello im trying to achieve something really fancy with my database like explained before, but i really suck with sql and i need some help please, by the way its in mysql but no one in that forum could help me so i posted here

 

table a

column common

column date

column name

column lastname

 

table b

column common

column date

column animal

column plant

column toy

 

table c

column common

column date

column electronic

 

table d

column common

column date

column vehicle

 

 

Lets say i want it to display each name and lastname of every person and display the sum of each animal, plant, toy, electronic and vehicle that each person have at a given date, even if one of them doesnt have a toy.

 

 

 

For example

 

 

 

 

 

name    lastname  animal  plant  toy    electronic  vehicle

 

peter      griffin        2            0          4          5              1

[mikosiko]

you must show what have you tried already.... if you don't know where to start here is a couple hints:

JOIN

SUM

 

put some effort studying  the examples, write some code, and come here with specific questions/doubts and sure someone will help.

[trq]

Your database design is the problem. Why do you have multiple tables containing the same types of data?

[ismael_lopez]

Well the columns are no really named like that its just an example with the same structure, but i mean I have tried like everything and could not do it