SQL Question

[mbaker33]

Hello,

I am writing a program that has an MDB database and I would like to be able to sort two tables using SQL. I am pretty sure it would be the most efficient way to do it.

basically, there are two tables. Both tables have a list of dates. I am looking to sort table2 by table1 so that if a date in table 1 matches taht in table 2 it doesn't display that date.

Basically the dates in table2 are a list of test. The dates in table1 is a list of test that have already been taken.

If anyone has any info, please post.

Thanks,
Mark

[Briantcva]

Use an INNER JOIN.

[HaxSoft]

Originally posted by mbaker33
Hello,

I am writing a program that has an MDB database and I would like to be able to sort two tables using SQL. I am pretty sure it would be the most efficient way to do it.

basically, there are two tables. Both tables have a list of dates. I am looking to sort table2 by table1 so that if a date in table 1 matches taht in table 2 it doesn't display that date.

Basically the dates in table2 are a list of test. The dates in table1 is a list of test that have already been taken.

If anyone has any info, please post.

Thanks,
Mark

Trying to understand the question: You have some records in table2 and want to display them ONLY if they do NOT appear in table1. Is that understood correctly?

You are using the date to link the tables, or another field or what?

[mbaker33]

basically I have a list of Dates in both tables. Table one contains dates of test that have already been taken. Table two contains the dates of all tests that have been published. I woul dlike it to show only the tests that haven't been taken.

[Briantcva]

sorry - misunderstood

check in acces for an "unmatched query wizard" and that will walk you through it