Welcome aboard! We are happy you are here and wish you good net-raft!
select ID_order from orders
where ID_order not in (select ID_order from products where name = 'pencil')
The most helpful SQL solutions
how to execute select into using sql ?SQL
Click to see more ...
727
53
convert string to date sqlSQL
Click to see more ...
641
42
How to get the last record from table using sql ?SQL
Click to see more ...
558
33
create table sqlSQL
Click to see more ...
333
23
How use like using sql ?SQL
Click to see more ...
412
22
How to get the last 10 records using mysql ?SQL
Click to see more ...
309
21
rows to columns sqlSQL
Click to see more ...
264
17
insert new column into table sqlSQL
Click to see more ...
265
16
How to convert the values to lowercase using sql ?SQL
Click to see more ...
284
13
How to change a negative number to positive using sql ?SQL
Click to see more ...
220
11