我现在有5个表
表1
sell_id  item_id
we0001   lw00001
we0002   lw00002
we0003   lw00003
表2
item_id  item_de_id
lw00001   ls00001
lw00002   hz00001
lw00003   dl00001
表3
ls_id    email
ls00001  [email]gu@[/email]
表3
hz_id    email
hz00001   [email]zp@[/email]
表4
dl_id    email
dl00001   [email]zw@[/email]
我现在要通过搜索email得到表1的ID,请问怎么写这个SQL语句.麻烦了各位.我想了很久.麻烦各位了

关键是不会写啊,单个的还能写出来.麻烦写出来一下可以吗?

select * from lw_item_account
where item_id in (
select item_id from lw_deputy_info,lw_item where lw_item.item_deputy_id=lw_deputy_info.deputy_id and deputy_email like '%"&search_supply&"%' order by deputy_id desc
 union
select item_id from lw_teacher_info,lw_item where lw_item.item_deputy_id=lw_teacher_info.teacher_id and item_teacher_email like '%"&search_supply&"%' order by teacher_id desc
  union
select item_id from lw_member_info,lw_item where lw_item.item_deputy_id =lw_member_info.member_id and member_email like '%"&search_supply&"%' order by member_id desc)
这样写对不对？