Not sure if this is the correct location for this question.

Excel 2010 Microsoft Query function. Pulling data from an external database using the Microsoft Query Wizard and ODBC.

Joined accounts in table1 and table2 by ID.
Table1 items: ID, PNID, END-DATE, STATUS
Table2 items: ID, END-DAT

I want to see accounts where 010725 and 048555 PNID's exist for the same account and the END-DATE and END-DAT = 99999999 and STATUS = A.

I've tried different ways to do this in the query, but only gets one or the other not both in the same account.

Thanks.