SELECT LAST, FIRST, PHONE, FAX,
Here is a queary (SQL) which combines 2 tables and adds some new fields for the output
SELECT LAST, FIRST, PHONE, FAX,
Here is a SQL statement which combines 2 seperate tables
You can use The JOIN method, Outter and Inner.
In this example several things have been done.
Pick 4 fields from a table named westwood
create a new column in the output titled NAME which would have Last, First fields
Take the FIRST field apend underscore then Append the LAST field and append @who.com and name the column EMAIL
Next is take the Uppercase of the first letter from the FIRST field and append it to the LAST field and title this column ID
Now the Union of another table (international) which doesnt have a common Key ID,
and some of the code repeats.
Hope this helps !!!!
------------------------------------------------------------------------
SELECT LAST, FIRST, PHONE, FAX,
LAST & ", " & FIRST AS NAME,
FIRST & "_" & LAST & "@who.com" AS EMAIL,
UCASE(LEFT(FIRST, 1) & LAST) AS ID
FROM westwood
UNION SELECT LAST, FIRST, PHONE, FAX,
LAST & ", " & FIRST AS NAME,
FIRST & "_" & LAST & "@who.com" AS EMAIL,
UCASE(LEFT(FIRST, 1) & LAST) AS ID
FROM international
ORDER BY LAST, FIRST;
------------------------------------------------------------------------- |
