A*, B*, C*, D*
(( A LEFT OUTER JOIN B ON A.StoreID= B.`StoreID` ) LEFT OUTER JOIN
C ON A.`StoreID`= C.`StoreID` ) LEFT OUTER JOIN
D ON A.`StoreID`= D.`StoreID`
B.`Year` = 2003 AND C.`Year` = 2003 AND C.`Year` = 2003
What I am trying to do is create a statement that will look into each database B,C,D and retreive fields which match the year 2003. The A database has 5 stores which must be included in the output, however databases B,C,D don't all have the year 2003 in it, what I want as a final output is all 5 stores, and if B,C,D databases have information for the year 2003 return it, otherwise just return blank.