How To make condition in SQL query statement

[juvi]

Hello,

I have got table "Material" with 2 types of materials A and B
my second table "Material_INFO_A"
my third table "Material_INFO_B"

how can I make my SQL query with condition?
I want to merge my query with the results for INFO from A and B for both
types of materials. Or can be this done by UNION SELECT?

thx
juvi

 

[John W. Vinson]

Hello,

I have got table "Material" with 2 types of materials A and B
my second table "Material_INFO_A"
my third table "Material_INFO_B"

how can I make my SQL query with condition?
I want to merge my query with the results for INFO from A and B for both
types of materials. Or can be this done by UNION SELECT?

thx
juvi

Either two queries, or one UNION query would work. It would help a lot if you
would explain what you mean by "SQL query with condition" and indicate how the
Material table relates to the A and B tables.