General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Kirk,
Have you tried the UNION command? You build two sql statements and put them together with a UNION command. It essentially will pull data from two unrelated tables into one query.
SELECT PCODE,PADR( PDESC,35 ) AS PDESC FROM Table1 UNION ALL SELECT PCODE,PADR( PALIAS,35 ) AS PDESC FROM Table2
Some issues to keep in mind: The two SELECT commands must have the same number of fields, the same data type and the same names. Also, I noticed one of the fields was C(35) and the other was smaller. You will want to force the smaller field to the larger size with a PADR command.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only