关于sql语句，大家帮忙

[Sean_chz]

用join关键字如何写多表查询？

以下写错了，要怎么写，谢谢！
select nickname,name from tUser u
join tUserGoodsRel and tUserGoodsRel ugr join tgoods g
on u.id=ugr.userid and ugr.goods=g.id

[zhuheyang]

select nickname,name from tUser u
join tUserGoodsRel ugr on u.id=ugr.userid join tgoods g
on ugr.goods=g.id

[paoluo]

Select nickname,name from tUser U
Inner Join tUserGoodsRel ugr On u.id=ugr.userid
Inner Join tgoods g On ugr.goods=g.id

[talantlee]

select nickname,name from tUser u
left join tUserGoodsRel ugr on u.id=ugr.userid left join tgoods g
and ugr.goods=g.id

[Sean_chz]

zhuheyang() 先