How To make condition in SQL query statement

  • Thread starter Thread starter juvi
  • Start date Start date
J

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
 
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
Click to expand...

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.
 
Back
Top