Multi table connection

[asparagas]

please, You can see the picture!

http://wwwz.sitemynet.com/question.jpg

 

[PHV]

You can see the picture
No

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[asparagas]

I'm so Sorry.
I am learning english.
I speak good not yet.
I live in Turkey.

 

[PHV]

What is the question ?
(

http://wwwz.sitemynet.com/question.jpg

is a broken link)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[asparagas]

No broken.
I can opened..!
Please, can you try right click and "Save as Target"?

http://wwwz.sitemynet.com/question.jpg

 

[asparagas]

Or,
Have you mail address?
I can post!

 

[PHV]

SELECT 'Table1' Table, UserID, RecDate, Subject FROM Table1
UNION SELECT 'Table2', UserID, RecDate, Subject FROM Table2
UNION SELECT 'Table3', UserID, RecDate, Subject FROM Table3
ORDER BY 2, 1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[asparagas]

Many thanks.
I will try as soon as possible.
" My server is broken

 

[PHV]

OOps, replace the order by clause:
ORDER BY 2, 3

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[asparagas]

Hello,
It is run
Thank you again.

One more question,
Which record from which Table?
How to understanding?