Query from 2 tables

[Blitz]

Hi,

I am trying to make a query based on 2 tables, but I need help.

Setup:
Table1 has a column with dates, and a column with yes/no (boolean)
Table2 has a column with dates, and several other columns

I made a one-on-one relationship between the dates from both tables. I cannot put the yes/no field in table2, because I need to import csv-data into table2, which seems to fail when there are more columns in table2 than in the csv-file.

Now I need a query that holds all the records from table2 that have a matching "no" in table1.

what is the SQL for that? I expect it will start with "select * from table2 where..."

I understand what they mean by "relationship" (and the different types of relationships), but I don't see how I can use those relationships in Access. Does SQL give different results for databases with / without defined relationships?



Should be an easy one for advanced users I guess...

[pbaldy]

Start a new query, select both tables. If no join line appears between the related date fields, click/drag to create one. Select the desired fields from the second table and the yes/no field from the first. Put 0 in the criteria of that field and run the query.

[June7]

The date value is unique in each table (only one record for each date, no time component)? Use the Access query designer to build query. Set a link between the two tables in the design window. The result will be like:

SELECT Table1.*, Table2.* FROM Table1 INNER JOIN Table2 ON Table1.[Datefield]=Table2.[Datefield] WHERE Table1.[Yes/no field] = No;