SQL Help Please...

  EmBeZzLeR 19:32 02 Jun 2003
Locked

How do i do the following:
List Manager's Name with their staffs' names, position and telephone number

Sno FName LName Address Tel_No Position Sex DOB Salary NIN Bno
SA9 Mary Howe 2 Elm Pl., Aberdeen AB2 3SU Assistant F 19-Feb-70 £9,000.00 WM532187D B7
SG14 David Ford 63 Ashby St., Partick, Glasgow G11 0141-339-2177 Deputy M 24-Mar-58 £18,000.00 WL220658D B3
SG37 Ann Beech 81 George St., Glasgow PA1 2JR 0141-848-3345 Snr Asst F 10-Nov-60 £12,000.00 WL432514C B3
SG5 Susan Brand 5 Gt Western Rd., Glasgow G12 0141-334-2001 Manager F 03-Jun-40 £24,000.00 WK588932E B3
SL21 John White 19 Taylor St., Cranford, London 0171-884-5112 Manager M 01-Oct-45 £30,000.00 WK442011B B5
SL41 Julie Lee 28 Malvern St., Kilburn NW2 0181-554-3541 Assissant F 13-Jun-65 £9,000.00 WA290573K B5



Please help,

Thx.

  EmBeZzLeR 19:35 02 Jun 2003

great it didnt come out how i wanted it to!!!

anyone wanna help me by addin me on their MSN?

my add: embezzler2002 @ hotmail . com

  Sir Radfordin™ 19:40 02 Jun 2003

hmmm! Its been a while...

Isn't it something like

Select FName, Lname, Address, Tel_no, Position from [tablename]

That will select the listed fields from the table that you put in.

  EmBeZzLeR 19:44 02 Jun 2003

I know how to start it but i don't know how to get both of the manager's names at the top of the table where the table names go... and then under each manager i have to display their staff and their position and tel_no

  Sir Radfordin™ 19:47 02 Jun 2003

Can you just list the fields we have to play with?

I presume you want to put out Manager X with Subordinate X and Manager Y with Subordinate Y. If so, how are they going to be identified as such?

  EmBeZzLeR 19:55 02 Jun 2003

This is taken from the staff table:

Manager's names: Susan Brand and John White

fields:

Sno: SA9

FName: mary

Lname: howe

Address: 21 whatever

Tel_No: 0141-339-2111

Position: Assistant

Sex: F

DOB: 19-Feb-70

Salary: 9k

NIN: WM5

Bno: B7

  EmBeZzLeR 21:22 02 Jun 2003

Staff
Sno FName LName Address Tel_No Position Sex DOB Salary NIN Bno
SA9 Mary Howe 2 Elm Pl., Aberdeen AB2 3SU Assistant F 19-Feb-70 £9,000.00 WM532187D B7
SG14 David Ford 63 Ashby St., Partick, Glasgow G11 0141-339-2177 Deputy M 24-Mar-58 £18,000.00 WL220658D B3
SG37 Ann Beech 81 George St., Glasgow PA1 2JR 0141-848-3345 Snr Asst F 10-Nov-60 £12,000.00 WL432514C B3
SG5 Susan Brand 5 Gt Western Rd., Glasgow G12 0141-334-2001 Manager F 03-Jun-40 £24,000.00 WK588932E B3
SL21 John White 19 Taylor St., Cranford, London 0171-884-5112 Manager M 01-Oct-45 £30,000.00 WK442011B B5
SL41 Julie Lee 28 Malvern St., Kilburn NW2 0181-554-3541 Assissant F 13-Jun-65 £9,000.00 WA290573K B5

  EmBeZzLeR 21:23 02 Jun 2003

Sno FName LName Address Tel_No Position Sex DOB Salary NIN Bno

  EmBeZzLeR 21:25 02 Jun 2003

SnoFName LName Address Tel_No Position Sex DOB Salary NIN Bno

  wawadave 21:27 02 Jun 2003

hope thats a factious list as they wont like there names and yearly incomes and phone no.s displayed in public.

  EmBeZzLeR 21:37 02 Jun 2003

It's taken from the DreamHomes Database

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Black Friday Deals 2017

How modern book design was influenced by illustrated manuscripts

Best Black Friday Apple Deals 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)