n4dhk91R

1how to combine multiple select query into one?
2CREATE TABLE IF NOT EXISTS `refrence` (
3  `products_ref_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4  `categories_id` int(11) NOT NULL,
5  `Product_property` varchar(255) NOT NULL,
6  `Product_reference` varchar(50) NOT NULL,
7  PRIMARY KEY (`products_ref_id`)
8) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
9
10
11CREATE TABLE IF NOT EXISTS `product_details` (
12  `products_id` int(11) NOT NULL AUTO_INCREMENT,
13  `categories_id` int(11) NOT NULL,
14  `FieldA` varchar(30) NOT NULL,
15  `FieldB` varchar(50) NOT NULL,
16  `FieldC` varchar(255) NOT NULL,
17  `FieldD` varchar(255) NOT NULL,
18  `FieldE` varchar(255) NOT NULL,
19  `FieldF` varchar(255) NOT NULL,
20  `Field_desc` text NOT NULL,
21  PRIMARY KEY (`products_id`)
22) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=98 ;
23	
24SELECT Product_reference FROM refrence where categories_id=3 AND Product_property ='xxx'
25	
26SELECT Distinct abc FROM product_details where categories_id=3
27	
28SELECT Distinct (
29SELECT Product_reference FROM refrence where categories_id=3 AND Product_property ='xxx'
30) as aa FROM product_details where categories_id=3
31	
32SELECT r.product_reference
33FROM refrence AS r 
34LEFT JOIN categories AS c ON (c.categories_id = r.categories_id AND r.categories_id=3 AND     r.product_property='zzz')
35WHERE c.categories_id=1