AND Statement

[crystalfun]

I've been out of programming and back into accounting for over a year so I forget everything. Please help.

I have an Access database with 2 tables. I want to return a value from Table 2. I forget how to write the formula.

If Field 1 and Field 2 from Table 1 = Field 1 and Field 2 from Table 2 then return Field 3 from Tbl 2.

Thanks in advance

 

[dakota81]

The SQL Query for that would go like this:

SELECT Table2!Field3 As Field3
FROM Table1, Table2
WHERE Table1!Field1 = Table2!Field1 AND Table1!Field2 = Table2!Field2

 

[OracleBaby]

My SQL statement is a little different. Lets say in Table1 you have 2 records that match Table2 then you may want 2 results not 4.

SELECT DISTINCTROW Table2.Field3
FROM Table1 INNER JOIN Table2 ON (Table1.Field1 = Table2.Field1) AND (Table1.Field2 = Table2.Field2);

Good Luck