Query Help!

Need Help In One Query Building

Page 1 of 1

5 Replies - 1549 Views - Last Post: 11 June 2009 - 07:26 AM Rate Topic: -----

#1 SukeshMarla  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 14-April 09

Query Help!

Posted 17 April 2009 - 03:12 AM


0


I Have 3 Tables
1.
Productmaster:
Columns:ProductId,PName,PDescription


2.
Attributes:
Columns:AttributeID,attName
this Table has Three Entries
1 Brand
2 Category
3 Artist

3.ProductAttributeValues Columns:paId,ProductId,AttributeID,AttributeValues

Conditions:1 Product can have Multiple Attributes

Needed Output
--------------------
ProductId | ProductDesc | Brand | Category | Artist..
1 | sadasd | Brand1 | Category1 | Artist1
2 | sadasds | Brand2 | Category3 | Artist4

I NOt Getting What should I Do To Get This O/p Pls Help Me Please Thanks in Advanc


Is This A Good Question/Topic? 0
  • +

Replies To: Query Help!

#2 OliveOyl3471  Icon User is offline

  • Everybody's crazy but me!
  • member icon

Reputation: 135
  • View blog
  • Posts: 6,581
  • Joined: 11-July 07

Re: Query Help!

Posted 17 April 2009 - 06:43 AM

First of all, this isn't the right forum for questions.
What language are you using...SQL?

Also, before you get an answer from this site, you'll need to at least show an effort:
[rules][/rules]

This post has been edited by OliveOyl3471: 17 April 2009 - 06:44 AM

Was This Post Helpful? 0
  • +
  • -

#3 BetaWar  Icon User is offline

  • #include "soul.h"
  • member icon

Reputation: 1509
  • View blog
  • Posts: 8,273
  • Joined: 07-September 06

Re: Query Help!

Posted 17 April 2009 - 10:08 AM

Moved to databases
Was This Post Helpful? 0
  • +
  • -

#4 SpaceMan  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 10
  • View blog
  • Posts: 507
  • Joined: 20-February 03

Re: Query Help!

Posted 17 April 2009 - 02:23 PM

would be a join type query, i don't know other DB type then MySQL and little MSSQL.
if one these your type.
left join will get all results for multiple types.
Was This Post Helpful? 0
  • +
  • -

#5 formadhukar  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 08-June 09

Re: Query Help!

Posted 11 June 2009 - 06:48 AM

Hi dear,

Use join to fetch the result.

Thanks,
Madhukar
Was This Post Helpful? 0
  • +
  • -

#6 Vomster  Icon User is offline

  • D.I.C Head

Reputation: 13
  • View blog
  • Posts: 198
  • Joined: 15-May 08

Re: Query Help!

Posted 11 June 2009 - 07:26 AM

All the information you require is at W3Schools
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1