Any SQL Nerds available?

select DISTINCT perhaps?

 

Between the IT thread and this, I think I'm going to start charging to do people's homework for them.

 

Can you use a LEFT JOIN

Example:

SELECT DISTINCT T1_NAME, T1_COL1, T1_COL2

FROM
T1


LEFT JOIN T2

ON T1_NAME = T2_NAME


WHERE

T1_COL1 <> 0 ;

 

Code:

SELECT * FROM BOOKS_AEROMAN10_CAN_READ WHERE SUBJECT LIKE 'SQL'

Lil Pun has a place for you to start.

This is basic SQL stuff, man... it just seems to me like you could learn these things yourself FIRST before you ask peeps here. Also, don't use the word 'Nerd' if you want help. You can call us GURUs or GENIUSes, but... that's cool.

 

One of those two tables has to be the "important" one with the data that is to be kept, if you're getting duplicates (basically, an "IF" statement that makes one the one to grab over the other one to say "this is the important one, if there is something in this one, grab it.") Now go learn more GENIUS stuff.

How about you post all those possible UNIONs and JOINs that you said you tried? We can decipher those and tell you what you're doing wrong. I will not post a query, because I want to see what you try. That's a lot easier because (supposedly), you've done the work. Right? Who's the nerd now?

 

Is there a need for Swoly-d*ckless to be an a-hole in every Clutchfans thread?

 

What database system are you using? A join should work (you may have to use a full outer join if names don't exist in both tables) and then a series of case statements to determine which table to get data from. I'm not sure if case statements are specific to MSSQL or standard SQL but other systems will have something similar.

Select
case when t2.name is not null then t2.name else t1.name end as finalName,
case when t2.col1 is not null then t2.col11 else t1.col1 end as finalValue
From t1
Full outer Join t2
on t1.name = t2.name

I haven't tested that code but the basic idea should work.

 

I'm not expert or anything, but isn't this a simple inner join...

Select * From T1 inner join T2 on T1.Name = T2.Name

Then just update T1.col# with T2.col#.

Unless I'm missing something here...

 

^ Like I said before, it was a join and a union, like Pun said. But we need to see what he has.

So... asking him for the queries he's tried... isn't a good thing?

Prove to me you're really trying, aeroman. It's a simple request. We nerds will take it from where ever you're stuck.

 

Thanks for posting what you used.

 

Odd, I always thought being called a nerd was a compliment. I guess I'll have to slap my girlfriend around the next time she calls me that...

 

Putting the where clause in both parts of the union should work.

 

create table t1
( fname varchar2(10), rank integer );

create table t2
( fname varchar2(10), rank integer );

insert into t1
select 'abc', 1 from dual
union
select 'xyz', 1 from dual;

insert into t2
select 'abc', 1 from dual
union
select 'xyz', 3 from dual
union
select 'opq', 2 from dual;

commit;

select * from t1;
select * from t2;

SELECT nvl(t1.fname, t2.fname),
nvl(t2.rank, t1.rank)
FROM t1, t2
WHERE t1.fname(+) = t2.fname

 

Yeah, this should work. I would use coalesce for clarity if it's available in whatever version of SQL you are using.

Select
coalesce (t2.name, t1.name) as name,
coalesce (t2.col1, t1.col1) as col1,
coalesce (t2.col2, t1.col2) as col2
From t1
Full outer Join t2
on t1.name = t2.name;

This is cleaner than using temp tables.

 

My company offers online training courses for various subjects, one of then being SQL. What would be a good to start learning first? What should I focus on?