Just a Web Code Solution
how to avoid to duplicates in sql join command ?
73
SQL
0
By 7 years ago
The power of the user (%)
0
// we want to get all records with SMILE happy and Field Node and Id 1003
//Table_1
//id SMILE
//1003 HAPPY
//1001 HAPPY
//1002 SAD
//1003 HAPPY
//1001 HAPPY
//1003 HAPPY
//Table_2
//id Field
//1003 Node
//1001 Java
//1002 PHP
//1006 Node
//1001 C
//1005 Node
select * from Table_1 T1 left join Table_2 T2 on T1.ID = T2.id and T2.Field = 'NODE' where T2.Field is not null and T1.SMILE = 'HAPPY' and T1.id = 1003
// this condition is very important "T2.Field is not null"
By 7 years ago
The power of the user (%)
The most helpful SQL solutions
how to execute select into using sql ?SQL
Click to see more ...
620
53
convert string to date sqlSQL
Click to see more ...
529
42
How to get the last record from table using sql ?SQL
Click to see more ...
454
33
create table sqlSQL
Click to see more ...
228
23
How use like using sql ?SQL
Click to see more ...
305
22
How to get the last 10 records using mysql ?SQL
Click to see more ...
199
21
rows to columns sqlSQL
Click to see more ...
154
17
insert new column into table sqlSQL
Click to see more ...
153
16
How to convert the values to lowercase using sql ?SQL
Click to see more ...
164
13
How to change a negative number to positive using sql ?SQL
Click to see more ...
117
11
- Related solutions:
- create table sql
228 23 - insert new column into table sql
153 16 - rename column sql
113 3 - convert string to date sql
529 42 - get date from datetime sql
84 1 -
Vote
1
- Latest solutions:
- create table sql
228 23 - insert new column into table sql
153 16 - rename column sql
113 3 - convert string to date sql
529 42 - get date from datetime sql
84 1 - get part of a string sql
76 0 - select year from datetime sql
113 1 - create table from select sql
136 3 - rows to columns sql
154 17 - delete table from databse sql
95 1 - Helpful solutions:
- how to execute select into using sql ?
620 53 - convert string to date sql
529 42 - How to get the last record from table using sql ?
454 33 - create table sql
228 23 - How use like using sql ?
305 22 - How to get the last 10 records using mysql ?
199 21 - rows to columns sql
154 17 - insert new column into table sql
153 16 - How to convert the values to lowercase using sql ?
164 13 - How to change a negative number to positive using sql ?
117 11
SQL
Would you like to receive an e-mail notification when new SQL solution is created?