Thank you Brenton, thank you Colin :-D
I used left join with the same logic and it does the trick.
Again thanks
Colin Guthrie-6 wrote:
>
> 'Twas brillig, and Brenton Alker at 23/06/09 04:22 did gyre and gimble:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> awesome wrote:
>>> I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
awesome wrote:
> I am new in Zend and relational database design.
>
> I have two tables that I would like to join in one so that certain values
> from 1st table are replaced with associated values from another table.
>
> This query works:
> SELECT a
I am new in Zend and relational database design.
I have two tables that I would like to join in one so that certain values
from 1st table are replaced with associated values from another table.
This query works:
SELECT a.iditems, a.model,
(SELECT name FROM headings WHERE idheadings = a.heading
