Union Query ... Help me

[history]

Hello friends

How are you

Please I need help in Union Queries
what does this code mean
"SELECT [Query_buy] ,Type.[Query_buy].Sum0 ,no AS InQuin , "Return" as Description From [Query_buy]"

I need to make combined report shows the reteurnd items.
I hope that my words are enough clear

Thank you all

 

[jdraw]

Hello friends

How are you

Please I need help in Union Queries
what does this code mean
"SELECT [Query_buy] ,Type.[Query_buy].Sum0 ,no AS InQuin , "Return" as Description From [Query_buy]"

I need to make combined report shows the reteurnd items.
I hope that my words are enough clear

Thank you all

I think this SQL
"SELECT [Query_buy] ,Type.[Query_buy].Sum0 ,no AS InQuin , "Return" as Description From [Query_buy]"

should be
"SELECT [Query_buy].Type,[Query_buy].Sum0 ,no AS InQuin , "Return" as Description From [Query_buy]"

What does this mean:

There is a query called "Query_buy"
The SQL above is attempting to retrieve/get columns
Type, Sum0,
and no but displayed as "InQuin", and the constant "Return" displayed as Description
from the Query ("Query_buy")

Also, this has nothing to do with Union queries.