Re: query from two tables & concat the result

>>
>> thetradinghall=> SELECT u.username ||'@'||d.domain as email_address
>> FROM email.mailusers u
>> INNER JOIN
>> email.domainlist d
>> ON
>> (u.domain_id=d.id);
>>
>> email_address
>> -----------------------------------
>> arnaud(dot)gaboury(at)thetradinghall(dot)com
>> (1 row)
>> -------------------------------------
>>
>> As for the cleaning of ID, I dropped id and changed both primary keys.
>> Thank you so much for your prompt answer and help.

In fact I kept the id for table domainlist (changed the name
accordingly your advise). If I remove the id column, I will not be
able anymore to do the above SELECT , no?
The condition (u.domain_id=d.id) will no more be possible.

Am I wrong?

>
> You're very welcome - glad to be able to help.
>
> R.
>
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod(at)iol(dot)ie

--

google.com/+arnaudgabourygabx