I hope I can describe what I am trying to do here...
I have 3 tables
LC_case
LC_ID
LC_name
LC_loans
LC_LN_ID
LC_LN
LC_LN_2
LC_loss
LS_LN
LS_amt
I am passing a value from a text box called fld_lc_id for LC_ID.
I need something like:

Select LC_ID, LC_name, LC_LN, LC_LN_2, LS_LN, LS_amt

FROM <BIG FAT JOIN>

WHERE LC_LN_ID = LC_ID AND (LS_LN = LC_LN OR LS_LN = LC_LN_2)

What I can't figure out is how to join them. LC_case is the top category that will contain multiple LC_loans. Some of the LC_loss records will match only LC_LN and some will only match LC_LN_2.
Should this be 2 queries with one calling another (which I have no idea how to do) or should it be one query?
Hope this makes at least a little sense.
Thanks in advance.