查询结果可以形成三个不同的表进入一个数组吗？

Question

I am trying to pull all of the records in each of these tables that have a value in Games.date_added that is greater than an inputed date. Trying to pull all the new records.

Can I do that all in one query? Or is it easier to just add a date_added field to each table and query each table separately?

GAMES
id
date_added
game_name
release_date
game_category
game_type
game_console

TROPHIES
trophies_id
game_name
tr_name tr_description
tr_color
tr_ach_value

TROPHY_TOTALS
trophy_totals_id
game_name
bronze_ttl
silver_ttl
gold_ttl
plat_ttl
hidden_ttl

Answer 1

It will be much better and clearer if you do 3 separate queries. Each one will give you a different amount of rows. The query given by glglgl that uses 2 joins will result in multiplied rows from the games table. This is because tropies and tropy totals can contain multiple records with same game. Of course if game_name is a unique column than the join will be OK.