Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
SQL Joins - newb Question
I was trying to condense what I was doing into simple form. My apologies Table A Record 1 Field 1 = 1 = Record ID Table A Record 1 Field 2 = 1 = Foreign Key Table B Table A Record 1 Field 3 = 2 = Foreign Key Table B Table B Record 1 Field 1 = 1 = Primary Key Table B Record 1 Field 2 = "YES"... -
SQL Joins - newb Question
I have a table A with fields that are foreign key integers for the primary key to another table B. The problem I am having is that I have multiple fields in Table A that are the same foreign keys to the primary key in table B. For Example: Table A Field 1 Record 1 = 1 Table A Field 2 Record...
