You need to add some field to the first query so that they have one field in
common on which you can do the join - I would expect that the employee
number would be contained in the source tables for the first query, so why
not add that to it.

Alec Wood

-----Original Message-----
From: Okeyemi Daniel
[mailto:mssqldba-ezmlmshield-x83135105.[Email address protected]
Sent: 31 March 2008 11:58
To: LazyDBA Discussion
Subject: Please help with this query

Please I need to join this two queries together. Any help would do.

select SALARY, BASIC_HOUR, FTE,SAL_DATE
from SALHISTY


select
EMPLOY_REF,FORENAME,SURNAME,GENDER,BIRTHDATE,STARTDATE,BANK_ACC,SORT_COD
E,DATE_LEFT,
TITLE, NI_NUMBER,STATUS,ADDRESS1,ADDRESS2,TOWN,TITLE, NI_NUMBER, STATUS,
ADDRESS1, ADDRESS2,
BIRTHDATE,BANK_ACC,POSTCODE, E_MAIL_ID, PAYROLL_NO, AREA_CODE,DIVISION,
DEPARTMENT,EMP_TYPE
from employee

Cheers,

Daniel Okeyemi
Database and Applications
Aspen Re-Insurance
30, Fenchurch Street, London EC3M 3BD
Direct Line 02071848977
Mobile1 07920494554
Email Daniel.[Email address protected]







The information in this email, including attachments, is confidential and
may be legally privileged. It is intended solely for the addressee(s). If
you are not the intended addressee(s), any disclosure, storage, copying,
distribution of this email or the information contained in it, or any action
taken or omitted to be taken in reliance on it, is prohibited and may be
unlawful. If you have received this email in error, please notify the sender
by return email and delete this email (including any attachments) from your
system. Please check any attachments for viruses before opening.

In the UK:
Aspen Insurance UK Limited, 30 Fenchurch Street, London, EC3M 3BD, UK. Tel:
+44 (0)207 184 8000. Company No: 1184193.
Authorised and regulated by the Financial Services Authority.

In Bermuda:
Aspen Insurance Limited, Maxwell Roberts Building, 1 Church Street,
Hamilton, HM 11, Bermuda. Tel: +1 441 295 8201.

In the US:
Aspen Re America Inc, 175 Capital Boulevard, Suite 300, Rocky Hill, CT
06067, USA. Tel: +1 860 258 3500.

In the UK, ASPEN is a registered trade mark of Aspen (Actuaries & Pensions
Consultants) plc of the UK and is used by Aspen Re under licence. Aspen Re
is a subsidiary of the Bermuda-based Aspen Insurance Holdings Limited
("AIHL"). AIHL and its subsidiaries are not affiliated in any way with Aspen
(Actuaries & Pensions Consultants) plc of the UK.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1350 - Release Date: 30/03/2008
12:32


No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1350 - Release Date: 30/03/2008
12:32



MS Sql Server LazyDBA home page