ISPrincess
Programmer
I am having a very hard time with this for whatever reason.
Say I have 3 tables (TABLENAME, FIELDNAME, VALUE)
TABLE 1
Field1
X
TABLE 2
Field1 Field2 Field3
X 1111 A
X 2222 B
Y 3333 C
TABLE 3
Field1 Field2
1111 A *
1111 B
2222 A
2222 B *
3333 C
I only want to return the records from Table3 that have field1 and field2 (combined) = field2 and field3 (combined) from table2 where field1 is = field1 in table1 which in this case is 'X'.
In order to return only the value asterisked from Table 3 - how would I write the query?
(I know this is going to be easy but I think I have been thinking about it too long or something)
Say I have 3 tables (TABLENAME, FIELDNAME, VALUE)
TABLE 1
Field1
X
TABLE 2
Field1 Field2 Field3
X 1111 A
X 2222 B
Y 3333 C
TABLE 3
Field1 Field2
1111 A *
1111 B
2222 A
2222 B *
3333 C
I only want to return the records from Table3 that have field1 and field2 (combined) = field2 and field3 (combined) from table2 where field1 is = field1 in table1 which in this case is 'X'.
In order to return only the value asterisked from Table 3 - how would I write the query?
(I know this is going to be easy but I think I have been thinking about it too long or something)