NAVIGATION
CATEGORIES
REFERRENCE
LINKS
customers in 2003, not 2004 (was "Help with (probably) simple query")
1 answers - 330 bytes -
I have 2 tables showing customers from 2003 and 2004.
They show customer number, customer name, and date attended.
I need to show what customers came in 2003, but not in 2004 by name. Problem with the customer number is that some times the customers lose their cards and get new numbers.
Any help is appreciated.No.1 | | 156 bytes |
| 
You will still have difference if also the name changed!
But you could try:
SELECT NAME FROM TAB2003
MINUS
SELECT NAME FROM TAB2004;
;)
QUESTION ON "ANSI SQL"
- Cursor limits
- cursor is having no rows but should show at least 2
- crosstab
- cross platform derived table query
- Creating Stored procedures
- creating stored procedure update
- Creating report using a loop
- Creating Record set using oracle procedures.
- Creating Output in columns instead of Rows
- Creating backup table
- Creating Access tables in SQL
- creating a text file from the contents of the database?
- creating a simple DB
- CreateFile() Error
- create temporary table in linux
- Create Table Question
- Create date Function using SQL
- Create Cursor with Dynamic SQL
- Create a View
- Create a Updated Form?
- Cumulative Field
- Creating Triggers
- Creating procedures in PL/SQL
- creating constraints
- CREATE TABLE with a DEFAULT for Microsoft Access
- Create row from number range
- Counting unresolved support calls based on two dates
- count distinct
- count 2 value in a table
- Correct syntax on this SQL INNER JOIN Query.
- Converting SQL numeric datatype to a mainframe (cobol) packed field
- Converting a (+) to an outer join in SQLServer
- Convert datetime to seconds
- Conditional SQL Statements?
- Conditional Count(*)
- Computer techies/ Engineers. IT people. Question about SQL.
- Complex Query or just me?
- Comparing 2 records
- Combining LEFT JOIN and MAX
- Combining info from two tables?