还是联合查询加条件的问题

[doudoushen]

下面是个查询语句，现在我想加点条件不知道怎么下手
部分字段

userinfo userID 主键 username(姓名)
cardinfo id 主键 userid外键
carinfo id 主键 cardid外键 userid外键 color(车子颜色)

select a.* ,carinfo.*,userinfo.* from (select * from cardinfo ) a
join userinfo on a.userid=userinfo.userid join carinfo on a.ID=carinfo.cardid and a.userID=carinfo.userid

如果只在cardinfo 上加条件比较简单只要在(select * from cardinfo ) 中加where 就行了
但是如果想在userinfo、carinfo表加条件就不知道怎么写了

举个例子
要查询 姓名='王*' color='blue'的3个表中所有字段 怎么写

[chuifengde]

select a.* ,carinfo.*,userinfo.*  from cardinfo a 
join userinfo on a.userid=userinfo.userid  join carinfo on a.ID=carinfo.cardid and a.userID=carinfo.userid 
where username like '王%' and color='blue'

[sweetweiwei]

--try
select a.* ,carinfo.*,userinfo.* from (select * from cardinfo ) a
join userinfo on a.userid=userinfo.userid join carinfo on a.ID=carinfo.cardid and a.userID=carinfo.userid
where userinfo.username = '王*'
and carinfo.color='blue'

[yfcomeon]

select a.* ,carinfo.*,userinfo.*  from cardinfo  
join userinfo  on cardinfo.userid=userinfo.userid  join carinfo on cardinfo.ID=carinfo.cardid and cardinfo.userID=carinfo.userid and userinfo.username like'王%' and carinfo.color='blue' 

[doudoushen]

谢谢各位，我觉得是否可以这样理解 不管是cardinfo ,userinfo, carinfo他们的条件都可以在最后where里过滤？
比如
cardinfo 中有个开卡时间
现在条件是 开卡时间在2008年之后 姓王的 车子颜色是blue的

select a.* ,carinfo.*,userinfo.* from cardinfo a
join userinfo on a.userid=userinfo.userid join carinfo on a.ID=carinfo.cardid and a.userID=carinfo.userid
where username like '王%' and color='blue' and a.time>'20080000000000'

[忆轩辕]

过滤条件都跟在where后面

[wh110]

select a.* ,carinfo.*,userinfo.*  from cardinfo a 
join userinfo on a.userid=userinfo.userid  join carinfo on a.ID=carinfo.cardid and a.userID=carinfo.userid 
where username like '王%' and color='blue'