-
query on more tables
Hi,
I've 2 tables:
TABLE AX:
ID NUMBER PK
TABLE BX:
ID NUMBER FK
TABLE A HAS 2000 RECORDS
TABLE B HAS 3500 RECORDS
I'd like to write a query to find 1500 record not equal.
I tried this:
select a.id, b.id
from ax a, bx b
where a.id <> b.id
group by a.id, b.id
but It not run correctly
How can I write this query??
Thanks
Raf
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|