...I hope its kind of clear now :-)
Not at all. In your first piost you stated that :
I have two totally different tables with completely different data fields.
Which means that you cannot use UNION, as it will require the same set of fields in both parts of union.
Using UNION you can select the common sub-set of the fields if there is one.
Also you said that:
Also, there is no common relationship between these two tables.
Which means that you cannot determine data from which row of Table2 should be selected for some row of Table1. So, the only reasonable suggestion is: you can built cartesian product - nothing else. (Actually, if youn number rows in both tables and join them based on this number, you will get nothing else other than subset of cartesion product, as you will still have no common relation between data of your two tables)
If you really want to get any relevant help, I strongly advised you to provide at least some small sample of your table DDL's and data, with explaining what results you would like to see from samples you posted.
Please read the forum etiquette article from the link at the bottom of my signature...
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)How to post your question to get the best and quick help