KrotovRoman
11/12/2013 - 5:34 AM

Соединение трех таблиц

Соединение трех таблиц

SELECT * 
	FROM pockets
INNER JOIN orders ON  `orders`.`hash_pocketa` =  `pockets`.`hash_pocketa` 
INNER JOIN options ON  `options`.`id` =  `orders`.`id_option` 
WHERE  `orders`.`id_user` =  '$Currentid

$query = "SELECT * 
		FROM users
		INNER JOIN clients ON  clients.id_user =  users.id  
		$query_search 
		ORDER BY users.id DESC LIMIT $start, $limit ";