This is what i have that I need help with. I have 4 Tables, that i need to tie together into a single query if possible. The below information represents the relational data between all fields
Table 1 Fields
NSID
NSID /NOPB
Table 2
Mfg Part #
Table 3
Mfr Part #
Table 4
NSID
Tables 2-4 are rather simple, its the Table 1 data that is teh caveat. On each Row I have a reference to NSID and NSID /NOPB which is the same as NSID in Table 4, and Mfg Part 3 and Mfr Part # in Tables 2 and 3. This is what they mean.
NSID - Mfg Part #
NSID /NOPB - Lead Free Equivalent of NSID
How do i tie the fields in table 1 to the other tables such that i can extract and manipulate the data from the other tables that i need?