Why the project number "Z%" cannot show

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

Why the project number "Z%" cannot show

Author

Topic

usafelix
Posting Yak Master

165 Posts

Posted - 2014-06-25 : 05:37:54

I have two table and using of inner join. The query statement is
select * from A inner join A.project_no = B.Project_no

Table A
Project_no
120270HK.0
000010.10
Z00009.10

Table B
Project_no
130270NT.0
000010.10
Z00009.10

The output is 12027hk.0 and 000010.10 and 130270NT.0 and missing of
Z0009.10.

How I can show all records include "Z000009.10" record?

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-06-25 : 05:44:58

select * from tablea A
inner join tableb B
on A.project_no=B.project_no

Javeed Ahmed

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources