Probably a dumb question but will provide a basic example for representation. I have 2 tables and a query with conditional statements. Table A is the primary (if you will) and if account exists in Table B, that would be a plus. If not, return null. Right now, it only returns the record if account exists in A and B. Example:

```
SELECT
A.id_nbr AS ID,
A.contact_type AS contype,
A.last_update AS date,
B.card_type as card_type
FROM id_info A,
     billing_info B
WHERE (A.contact_type = 'AAA' OR A.contact_type = 'BBB' OR A.contact_type = 'CCC')
AND A.id_nbr = B.id_nbr;

```

If record exists, great:

```
ID          contype     date         card_type
111111111   AAA         2020-02-21   MS

```

If not, great too:

```
ID          contype     date         card_type
222222222   AAA         2020-02-21   null

```

Basically, I don't want to negate the entire record if it doesn't exist in table B.
Any suggestions are appreciated. Thank you very much!