query question

  • Thread starter Thread starter golan
  • Start date Start date
G

golan

hello, i have a query that show who dont pay (at all) and a query that show
who obliged .
i want to show the results together ?

the tables are contracts , payments .
 
You need a UNION query. This will break unless the columns are matched, but
it will look like this ...


SELECT * FROM qryThoseWhoPay
UNION SELECT * FROM qryThoseWhoDont

To be safe, replace the * with a list of actual columns.
 
Back
Top