query question

[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 .

 

[Danny Lesandrini]

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.