t.train_no

how to use a value of other table as table name for another SELECT statement in Access? i am currently using this statement SELECT DISTINCT t.train_no, t.train_name FROM train_info_submit t, msg_info_submit m WHERE t.train_no=m.train_no ORDER BY t.train_no now i have tables with table...