I joined two tables with the left inner join so I insert into table1 and leave table2 empty and I go the result,
But when I do a condition : table1 left inner join table2 on ..... WHERE (TABLE1.COLUMN1='Yes' and TABLE2.COLUMN1=NULL) I don't get any result and I don't understand why
If the table2 is empty doesn't mean that it's columns are equal to NULL ?
salim20001
Member
154 Points
507 Posts
Joining tables
Mar 26, 2012 04:56 PM|LINK
H,
I joined two tables with the left inner join so I insert into table1 and leave table2 empty and I go the result,
But when I do a condition : table1 left inner join table2 on ..... WHERE (TABLE1.COLUMN1='Yes' and TABLE2.COLUMN1=NULL) I don't get any result and I don't understand why
If the table2 is empty doesn't mean that it's columns are equal to NULL ?
adamturner34
Contributor
4394 Points
1102 Posts
Re: Joining tables
Mar 26, 2012 04:59 PM|LINK
Hmmm...there's no such thing as a left inner join. A LEFT JOIN is always an outer join.
Just running LEFT INNER JOIN should error out.
gimimex
Participant
1052 Points
157 Posts
Re: Joining tables
Mar 26, 2012 07:04 PM|LINK
Hi,
Instead of
try:
I hope this helps.
salim20001
Member
154 Points
507 Posts
Re: Joining tables
Mar 26, 2012 09:18 PM|LINK
Yes left OUTER join of course !!!
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Joining tables
Mar 28, 2012 01:30 AM|LINK
It seems that your problem is solved？If yes，would you mind sharing us your nice solution？
Welcome you to our forum next time to chat with us about the latest technology of ASP.NET……