Recieving Syntax Error using "OR" command

[Adigga1]

Hello,

I am attempting to call a particular table if the OR statement is used. When I try it gives me a Syntax error. Please assist?

Here is the code:

SELECT T_Physicians.TaxID, T_ECCcpt.CPTcode, T_ECCcpt.Charge, *
FROM T_Physicians, T_ECCcpt
WHERE (((T_Physicians.TaxID)="58-229xxxx"))
OR
SELECT T_Physicians.TaxID, T_SibleyCpt.CPTcode, T_SibleyCpt.Charge, *
FROM T_Physicians, T_SibleyCpt
WHERE
T_Physicians.TaxID = 58-187xxxx;


Adigga1

 

[Adigga1]

Thank you Pat;

What I'm attempting to establish is a condition i suppose whereby, when a particular TaxID is selected that represents ECC the corresponding ECC CPT table is referenced where i have to option to select the CPT code and price from that table.

I have all of the Physicians and TaxID; CPT and Prices loaded in their respective tables and fields.

I am seeking the correct coding to use in order to accomplish this. I am pretty new to coding so please be patient with me?

Thank you.