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 !
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 !