Unique values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have two tables of restaurant data, one shows all items rung through a
till, the other shows how each check was paid off.
The link between the two is the 'check id'

I want to write a query which shows all checks and the detail for tables
with zero covers (customers) rung through.

The table which has paid off history shows covers.

I have created the query, and for some reason it will not screen out zero
covers even though i have put it as a criteria.

Can anyone tell me how i get it to show all unique vales
 
Post your SQL statement. Give an example of your data and what you want for
results of the query.
 
Back
Top