Conditional Query

[thegladiator]

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?

[weekend00]

can you list all the fields of the 4 tables?