gothedistance · September 11, 2015 15:05
diff --git a/postgre_join_condition.sql b/postgre_join_condition.sql
 select
 	c.customer_id,
 	c.customer_age,
 	c.customer_name,
 	ca.name,
 	ca.rank
 from
 	customers as c
 	inner join customer_category as ca 
 	on (c.customer_age /5 *5) = ca.rank
 where
 	c.customer_id <= 100
	select
	c.customer_id,
	c.customer_age,
	c.customer_name,
	ca.name,
	ca.rank
	from
	customers as c
	inner join customer_category as ca
	on (c.customer_age /5 *5) = ca.rank
	where
	c.customer_id <= 100