On 7/10/08 5:52 PM, "yogi_raj_143" <[EMAIL PROTECTED]> wrote:
> Hello,
> I need some help in creating mySQL query,
>
> I have a database in format
>
> Year Brand Rel
> 1990 ABC 5
> 1990 PQR 4
> 2000 ABC 3
> 2000 PQR 2
>
>
> I want to display this data in format
> Year Brand_ABC_Rel Brand_PQR_Rel, ie
> 1990 5 4
> 2000 3 2
>
> Pls let me know the mYSQL for the same...
>
Hmmm...from my point of view, without knowing more about your database, I
would have designed the tables and relatoinships differently....you can do
internal relationships I know, but they aren't my strong point...
