Reply to thread

Message

<blockquote data-quote="hspa3.5" data-source="post: 19795285" data-attributes="member: 240341">මට SQL හෙල්ප් එකක් දීපල්ලකෝ ?මචන්ලා මට SQL හෙල්ප් එකක් දීපල්ලකෝ ?මන් ගාව ටේබල් දේකක් තියෙනවා Join කරන්න ඕනේ.Product table&nbsp; product_id&nbsp; &nbsp; |||&nbsp; Product_name&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ||&nbsp; &nbsp;&nbsp; aaaa&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ||&nbsp; &nbsp;&nbsp; bbbb Product_Attributes&nbsp; Product_id&nbsp;&nbsp; |||&nbsp; &nbsp;&nbsp; Attribute_type&nbsp; |||&nbsp; &nbsp; Attribute_value&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp;&nbsp; Brand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ABC&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp;&nbsp; Category&nbsp; &nbsp; &nbsp;&nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XYZ&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp; &nbsp; Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PQR&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Brand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ABC&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Category&nbsp; &nbsp; &nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; XYZ&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; LSTමට ඕනේ Attribute_type එක parameter එක විදිහට දීල product select කර ගන්න ඕනේ..select * from product p,product_attributes pawhere p.product_id=pa.product_id andpa.Attribute_type='Brand' and pa. Attribute_value='ABC'&nbsp;&nbsp; andpa.Attribute_type='Category' and pa. Attribute_value='XYZ'&nbsp;&nbsp; ;ඔය විදිහට හැදුවට product pick වෙන්නේ නැ... දන්නා එකෙක් උදව් කරපියව් ..හදිස්සි&nbsp; 8+</blockquote>

[QUOTE="hspa3.5, post: 19795285, member: 240341"] [b]මට SQL හෙල්ප් එකක් දීපල්ලකෝ ?[/b] [SIZE="4"]මචන්ලා මට SQL හෙල්ප් එකක් දීපල්ලකෝ ? මන් ගාව ටේබල් දේකක් තියෙනවා Join කරන්න ඕනේ.[/SIZE] [U]Product table[/U] product_id ||| Product_name 1 || aaaa 2 || bbbb [U]Product_Attributes[/U] Product_id ||| Attribute_type ||| Attribute_value 1 || Brand || ABC 1 || Category || XYZ 1 || Type || PQR 2 || Brand || ABC 2 || Category || XYZ 2 || Type || LST [SIZE="4"][COLOR="Blue"]මට ඕනේ Attribute_type එක parameter එක විදිහට දීල product select කර ගන්න ඕනේ..[/COLOR][/SIZE] 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' ; [SIZE="5"][COLOR="Red"]ඔය විදිහට හැදුවට product pick වෙන්නේ නැ... දන්නා එකෙක් උදව් කරපියව් ..හදිස්සි 8+[/COLOR][/SIZE] [/QUOTE]

Verification

Asuwa dahayen wadi kalama keeyada?

Search

Latest ads

Reply to thread