求两张表查询问题?

[cqhweb]

现有两张表
A表(SMS_ID 主键)如下数据:

SMS_ID NOTES_ID MOBILE ADDRESSEE CONTENT
391 bailaxiusx 13734039384 赵六 早上
397 bailaxiusx 13734039384 李四 你好
418 bailaxiusx 13012345679 世界
513 tangshuyao 13734039387 张三
..........

b表(RECEIVESMS_ID 主键) 如下数据:

RECEIVESMS_ID NOTES_ID MOBILE ADDRESSEE CONTENT
83 bailaxiusx 13734039384 AA
100 bailaxiusx 13734039384 赵六 BB
101 tangshuyao 13734039384 CC
102 fenjunjie 13734039384 DD
......

--------找出 NOTES_ID ='bailaxiusx' MOBILE='13734039384' 结果如下:


SMS_ID RECEIVESMS_ID NOTES_ID MOBILE ADDRESSEE CONTENT
391 bailaxiusx 13734039384 李四 早上
397 bailaxiusx 13734039384 李四 你好
83 bailaxiusx 13734039384 AA
100 bailaxiusx 13734039384 赵六

[sdhdy]

select SMS_ID,'' as RECEIVESMS_ID,NOTES_ID,MOBILE,ADDRESSEE,CONTENT from ta where NOTES_ID ='bailaxiusx' and MOBILE='13734039384'
union all
select '' SMS_ID,RECEIVESMS_ID,NOTES_ID,MOBILE,ADDRESSEE,CONTENT from tb where NOTES_ID ='bailaxiusx' and MOBILE='13734039384'

[JonasFeng]

这样就OK了。

SELECT SMS_ID,'' as RECEIVESMS_ID,NOTES_ID,MOBILE,ADDRESSEE,CONTENT FROM ta  
WHERE NOTES_ID ='bailaxiusx' and MOBILE='13734039384'
UNION ALL 
SELECT '' SMS_ID,RECEIVESMS_ID,NOTES_ID,MOBILE,ADDRESSEE,CONTENT FROM tb  
WHERE NOTES_ID ='bailaxiusx' and MOBILE='13734039384' 

[ahwanbing]

SELECT A.SMS_ID,B.RECEIVESMS_ID,A.NOTES_ID,A.MOBILE,A.ADDRESS,A.CONTENT FROM A表 A
INNER JOIN B表 B ON A.NOTES_ID = B.NOTES_ID
WHERE A.NOTES_ID='bailaxiusx' AND A.MOBILE='13734039384'