මට SQL හෙල්ප් එකක් දීපල්ලකෝ ?

hspa3.5 · Mar 2, 2016

මට SQL හෙල්ප් එකක් දීපල්ලකෝ ?

මචන්ලා මට SQL හෙල්ප් එකක් දීපල්ලකෝ ?

මන් ගාව ටේබල් දේකක් තියෙනවා Join කරන්න ඕනේ.

Product table

product_id ||| Product_name
1 || aaaa
2 || bbbb

Product_Attributes

Product_id ||| Attribute_type ||| Attribute_value
1 || Brand || ABC
1 || Category || XYZ
1 || Type || PQR

2 || Brand || ABC
2 || Category || XYZ
2 || Type || LST

මට ඕනේ Attribute_type එක parameter එක විදිහට දීල product select කර ගන්න ඕනේ..

select * from product p,product_attributes pa
where
p.product_id=pa.product_id and
pa.Attribute_type='Brand' and
pa. Attribute_value='ABC' and
pa.Attribute_type='Category' and
pa. Attribute_value='XYZ' ;

ඔය විදිහට හැදුවට product pick වෙන්නේ නැ... දන්නා එකෙක් උදව් කරපියව් ..හදිස්සි 8+

Executer · Mar 2, 2016

RottenCOLT · Mar 2, 2016

sajith.xp.pk · Mar 2, 2016

Joint query nam danne ne ban... umbata wenna ona de hariyatama kiyapan.. ethakota join query ekakin nathuwa wede kara ganna heti kiwweheki

Fire123 · Mar 2, 2016

select * from product p,product_attributes pa
where
p.product_id=pa.product_id and
pa.Attribute_type='Brand' and
pa. Attribute_value='ABC' or
pa.Attribute_type='Category' or
pa. Attribute_value='XYZ' ;

mehema balahan

lkzombie · Mar 2, 2016

PHP:

SELECT * FROM tbl_product_table INNER JOIN tbl_product_attributes ON tbl_product_table.product_id=tbl_product_attributes.product_id
WHERE tbl_product_table.product_id='0001' AND 
tbl_product_attributes.Attribute_type='Brand' AND
tbl_product_attributes.Attribute_value='ABC' AND
tbl_product_attributes.Attribute_type='Category' AND
tbl_product_attributes.Attribute_value='XYZ' ;

PS: Product ID eke data type eka numeric nam single quote eka ain karanna

shenic · Mar 2, 2016

Product table>> (products)
id , Product_name

Product Attributes table >> (product_attributes)
id , product_id , attribute_type , attribute_value

SELECT p.Product_name , a.attribute_value FROM products p JOIN product_attributes a ON p.id = a.product_id WHERE a.attribute_type = 'type_xxx' ORDER BY...... etc

Naradapathum · Mar 2, 2016

බම්ප් මචං..

තොත්ත බබා · Mar 2, 2016

SELECT product.product_id,product.Product_name
FROM product
INNER JOIN Product_Attributes
ON product.product_id=Product_Attributes.product_id where Product_Attributes. Attribute_type ='Brand'

try this

තොත්ත බබා · Mar 2, 2016

http://www.w3schools.com/sql/sql_join_inner.asp

hspa3.5 · Mar 2, 2016

Fire123 said:
select * from product p,product_attributes pa
where
p.product_id=pa.product_id and
pa.Attribute_type='Brand' and
pa. Attribute_value='ABC' or
pa.Attribute_type='Category' or
pa. Attribute_value='XYZ' ;

mehema balahan

lkzombie said:

PHP:

SELECT * FROM tbl_product_table INNER JOIN tbl_product_attributes ON tbl_product_table.product_id=tbl_product_attributes.product_id
WHERE tbl_product_table.product_id='0001' AND 
tbl_product_attributes.Attribute_type='Brand' AND
tbl_product_attributes.Attribute_value='ABC' AND
tbl_product_attributes.Attribute_type='Category' AND
tbl_product_attributes.Attribute_value='XYZ' ;

PS: Product ID eke data type eka numeric nam single quote eka ain karanna

shenic said:
Product table>> (products)
id , Product_name

Product Attributes table >> (product_attributes)
id , product_id , attribute_type , attribute_value

SELECT p.Product_name , a.attribute_value FROM products p JOIN product_attributes a ON p.id = a.product_id WHERE a.attribute_type = 'type_xxx' ORDER BY...... etc

තොත්ත බබා;19795607 said:
SELECT product.product_id,product.Product_name
FROM product
INNER JOIN Product_Attributes
ON product.product_id=Product_Attributes.product_id where Product_Attributes. Attribute_type ='Brand'

try this

තොත්ත බබා;19795610 said:
http://www.w3schools.com/sql/sql_join_inner.asp

ekin eka try karanava .. thanks bro

hspa3.5 · Mar 2, 2016

Fire123 said:
select * from product p,product_attributes pa
where
p.product_id=pa.product_id and
pa.Attribute_type='Brand' and
pa. Attribute_value='ABC' or
pa.Attribute_type='Category' or
pa. Attribute_value='XYZ' ;

mehema balahan

not working ban

results godak enava..thanks bro

deepwater · Mar 2, 2016

Mulinma uba ahala thiyana deta uththare
select * from product where id in
(select distinct product_id from product_attributes where
Attribute_type='Brand' and Attribute_value='ABC'
UNION
select distinct product_id from product_attributes where
Attribute_type='Category' and Attribute_value='XYZ'
);

mama kiyanne ube table structure eka waradi ban, uba columns vidihata , Brand ,Category , Type add karahan product attributes table eke. ethakota sort karana eka lesi
me thiyana widihata kawadahari expand karanta unoth complicate wenawa. Issella SQL igena ganin ethakota ubata hari widihak penei.

SaNDun · Mar 2, 2016

ithin oke results godak enawa thamai..mokada uba check karanne Attribute_type. Attribute_type ekata adalawa products onama ganak thiyenna puluwan.

rosharavinda · Mar 2, 2016

deepwater said:
Mulinma uba ahala thiyana deta uththare
select * from product where id in
(select distinct product_id from product_attributes where
Attribute_type='Brand' and Attribute_value='ABC'
UNION
select distinct product_id from product_attributes where
Attribute_type='Category' and Attribute_value='XYZ'
);

mama kiyanne ube table structure eka waradi ban, uba columns vidihata , Brand ,Category , Type add karahan product attributes table eke. ethakota sort karana eka lesi
me thiyana widihata kawadahari expand karanta unoth complicate wenawa. Issella SQL igena ganin ethakota ubata hari widihak penei.

mcn me yaluwa kiyala thiyena de hariyatama hari. umbe table structure eka
waradi. umba columns walata enna one ewa records karagena methana wade naala thiyenne. DB normalization igena ganin kolla. serama hariyai

hspa3.5 · Mar 2, 2016

deepwater said:
Mulinma uba ahala thiyana deta uththare
select * from product where id in
(select distinct product_id from product_attributes where
Attribute_type='Brand' and Attribute_value='ABC'
UNION
select distinct product_id from product_attributes where
Attribute_type='Category' and Attribute_value='XYZ'
);

mama kiyanne ube table structure eka waradi ban, uba columns vidihata , Brand ,Category , Type add karahan product attributes table eke. ethakota sort karana eka lesi
me thiyana widihata kawadahari expand karanta unoth complicate wenawa. Issella SQL igena ganin ethakota ubata hari widihak penei.

ohoma attribute table eka thiyala thiyenne ban ona welawaka table change ekak nokara ona attribute ekak add karanna ban..anika ape attribute jathi godak thiyenava ban ethakota columns 20,30k set wenawa.

sajith.xp.pk · Mar 2, 2016

උඹට වෙන්න ඕන දේ සිංහලෙන් වචනෙන් පැහැදිලිව කිව්වොත් SQL Structure එක හරියට කියල දීල Query එක එන්න ඕන විදිය කියන්නම්..

shenic · Mar 2, 2016

ube table eke structure eke hatiyata results godak enawa thama ban.
ekko structure eka wenas karapan.
naththan result eka 1 kakata limit karapan

sajith.xp.pk · Mar 3, 2016

කියපංකො උඹට වෙන්න ඕන දේ Technical නොවන විදියට ඒ කිව්වෙ මෙන්න මේක කරාම අරෙහෙම වෙන්න ඕන කියල පොඩි එකෙකුට කියල දෙන විදියට.. එතකොට හරි විදිය කියන්නම් ඕක කරන විදිය කෝඩ් එක්කම.. :sorry:

hspa3.5 · Mar 3, 2016

sajith.xp.pk said:
කියපංකො උඹට වෙන්න ඕන දේ Technical නොවන විදියට ඒ කිව්වෙ මෙන්න මේක කරාම අරෙහෙම වෙන්න ඕන කියල පොඩි එකෙකුට කියල දෙන විදියට.. එතකොට හරි විදිය කියන්නම් ඕක කරන විදිය කෝඩ් එක්කම..

මේකයි මචන් සීන් එක..මට ඕනේ රිපෝර්ට් එකකට product_attribute table එකෙන් brand එකයි category ,type parameter විදිහට දීල product ටික select කරගන්න ඕනේ..

ex: brand : Toyota
category :sedan
type

etrol vehicle නම් ටික ගන්න ඕනේ.

මට SQL හෙල්ප් එකක් දීපල්ලකෝ ?

Well-known member

Awrudu Games 2017 - Winners

Well-known member

Well-known member

Active member

Well-known member

Member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Member

Well-known member

Well-known member

Similar threads