简单的SQL语句

刚看了下基本的一些简单的SQL语句：顺便在这儿做个记录：

SELECT orders.*,
        user.username,
        user.sex,
        user.address,
        user.birthday
 FROM mybatis.orders,mybatis.user where orders.user_id=user.id;

 SELECT orders.*,
        user.username,
        user.sex,
        user.address,
        user.birthday,
        orderdetail.id orderdetail_id,
        orderdetail.items_id,
        orderdetail.orders_id,
        orderdetail.items_num
 FROM mybatis.orders,mybatis.orderdetail,mybatis.user 
 where orders.user_id=user.id and  orders.id=orderdetail.orders_id;

 
  SELECT orders.*,
user.id userid_id,
        user.username,
        user.sex,
        user.address,
        user.birthday,
        orderdetail.id orderdetail_id,
        orderdetail.items_id,
        orderdetail.orders_id,
        orderdetail.items_num,
        items.createtime items_createtime,
        items.detail,
        items.id item_id,
        items.name item_name,
        items.pic,
        items.price
 FROM mybatis.orders,mybatis.orderdetail,mybatis.user,mybatis.items
 where orders.user_id=user.id and  orders.id=orderdetail.orders_id and items.id=orderdetail.items_id;
 
 SELECT 
user.id,
user.username,
user.sex,
items.name item_name,
items.price
FROM mybatis.orders,mybatis.orderdetail,mybatis.user,mybatis.items
where orders.user_id=user.id and orders.id=orderdetail.orders_id and
items.id=orderdetail.items_id;
        
select * from mybatis.user,mybatis.orders where orders.user_id=user.id;
select * from mybatis.orders;

//这是延迟加载的一种简单的查询方法语句
select orders.*,
(select username from  mybatis.user where user.id=orders.user_id)username,
(select sex from  mybatis.user where user.id=orders.user_id)sex,
(select birthday from  mybatis.user where user.id=orders.user_id)birthday,
(select address from  mybatis.user where user.id=orders.user_id)address
         from mybatis.orders;

这些都是最基本的语句关联查询。注意这儿有的语句使用到了别名。