select $*$

from customers as c$,$ orders as o

where c$.$customer$\_$id $=$ o$.$order$\_$customer$\_$id and o$.$order$\_$date $>\text{'}2014-7-23\text{'}$ order by c$.$customer$\_$id;

it has $5$ columns

it has all columns from $2$ tables

it has $2$ columns

it has all columns from $1$ table