Joining Tables and queries

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello what I need is to unite 2 tables and one SQL query
together and then base a form on that one query.

I have an SQL query which has a UNION ALL statement in it
and I need to add to a new query this one query and the
other two tables and only show the records that they hold.

Is there a way to do this?

Many Thanks

James
 
Hello what I need is to unite 2 tables and one SQL query
together and then base a form on that one query.

I have an SQL query which has a UNION ALL statement in it
and I need to add to a new query this one query and the
other two tables and only show the records that they hold.

Is there a way to do this?
Click to expand...

I'm sure there is, but without knowing anything about the nature of
the queries nor how you want them to be joined, I really can't make
any suggestions, other than that it sounds like you want another UNION
query unioning this first query and the other two tables. Care to post
the SQL and the table definitions?
 
Back
Top