select * from xyzTable T1

inner join xyzTable2 T2 on T1.ID=T2.ID

Where...

To combine the results of two tables or more use the join clause. Lookup left and right join. Most common is the inner, which tells sql only display data when...

If you're allowing null values but don't want to display a null value to your customers, do this.

select isNull(fld1,'')

or

select isNull(fld1,'N/A')

If you're allowing nullo values in the field and you don't want to display null values do this.

select fld1,isnull(fld2,'')

or

select fld1,isnull(fld2,'Something')

As you once did, right JOHNROWAN!

In order to use the UNION on a select. The selects must have the same amount of fields. If some don't then use something like this.

select 'A','B','C'

union

select 'A','B',''

Instead of manually creating the table import it using dts or ssis.

SQL will only return a entire recordset. If you need to inspect some column in each row and do something with the column. You will need to use the FETCH...

Thanks guys. Heres the answer. I Completely forgot about the case clause.

UPDATE Salaries

SET Salary =

CASE

WHEN (Salary between 30000 and 40000) THEN Salary + 50000

WHEN (Salary...