Hi-
I'm doing this in access, but I think the question can be handled in most situations.
say I have two tables with names and addresses and stuff. I want to build a SQL query that pulls the name field from both tables and puts them in the same column so I can build a report using all the names from both tables.
I'm not having much luck - any ideas?
I'm doing this in access, but I think the question can be handled in most situations.
say I have two tables with names and addresses and stuff. I want to build a SQL query that pulls the name field from both tables and puts them in the same column so I can build a report using all the names from both tables.
I'm not having much luck - any ideas?