selecting more fields in one by a format

humer

Registered User.
Local time
Today, 01:00
Joined
Feb 10, 2004
Messages
14
Hello !!
I have a address composed frrom more fields: Street, Town, Region and Zip Code. I want to made a guery that will made only one field with all the information.

Another question with the same idea. I have 2 tables relied by the 3rd table to make a relation: infinite to infinite for the first 2 tables. The fisrt table is NGO, key - ngo_id, second table is Lang with two fields: lang_id ad Label. The 3rd tabel is made from id (key, autoincriment), ngo_id and lang_id.
Question: is it possible to make a column in the query that will contain the labels separates by spaces from the table Lang relied by the criteria from the 3rd table ???

thanks

best regard !
 
humer said:
Hello !!
I have a address composed frrom more fields: Street, Town, Region and Zip Code. I want to made a guery that will made only one field with all the information.

Address: [Street] & " " & [Town] & " " & [Region] & " " & [Zip]

would do it for you in a query.

Not sure what your third question really is, but since you have the keys for the other two tables in a table you can join those tables by those keys.
SELECT ColumnSelectionList
FROM NGO N
INNER JOIN NGO_LANG_XREF X ON N.ngo_id = X.ngo_id
INNER JOIN LANG L on L.lang_id = X.lang_id
WHERE SelectionCriteria
 

Users who are viewing this thread

Back
Top Bottom