* Hello to all VFP-SQL Professionals,

* I search an solution to get Post Rows from a Adresstable.
* For example, I have got this Sourcetable:
* TabSource.dBF
*+------------+---------+--------+-------------+------------+
*|Company |FirstName|LastName|Street |City |
*|c(20) |c(10) |c(10) |c(20) | |
*+------------+---------+--------+-------------+------------+
*| |Mickey |Mouse |MainStreet 1 |Disneyland |
*|Wondercars |Batman | |Castle 12 |Gotham City |
*| |Donald |Duck |PoorStreet 13|Ducktown |
*+------------+---------+--------+-------------+------------+

* The SQL Command to get a Targettable with PostRows is easy.
SELECT company as PostRow1, ;
ALLTRIM(firstname+" "+lastname) as PostRow2, ;
street as PostRow3, ;
city as PostRow4 ;
FROM TabSource ;
INTO TABLE TabTarget1

* So I get this TabTarget1.dBF
*+------------+-------------+-------------+------------+
*|PostRow1 |PostRow2 |PostRow3 |PostRow4 |
*+------------+-------------+-------------+------------+
*| |Mickey Mouse |MainStreet 1 |Disneyland |
*|Wondercars |Batman |Castle 12 |Gotham City |
*| |Donald Duck |PoorStreet 13|Ducktown |
*+------------+-------------+-------------+------------+
* But this is not really a Table with PostRows.
*
* How knows the SQL solution, to get this Targettable
* with this real PostRows.
*+------------+-------------+-------------+------------+
*|PostRow1 |PostRow2 |PostRow3 |PostRow4 |
*+------------+-------------+-------------+------------+
*|Mickey Mouse|MainStreet 1 |Disneyland | |
*|Wondercars |Batman |Castle 12 |Gotham City |
*|Donald Duck |PoorStreet 13|Ducktown | |
*+------------+-------------+-------------+------------+

* Many thanks for help.