SQL Help Please...

  EmBeZzLeR 19:32 02 Jun 03
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 03

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 03

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 03

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 03

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 03

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 03

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 03

Sno FName LName Address Tel_No Position Sex DOB Salary NIN Bno

  EmBeZzLeR 21:25 02 Jun 03

SnoFName LName Address Tel_No Position Sex DOB Salary NIN Bno

  wawadave 21:27 02 Jun 03

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 03

It's taken from the DreamHomes Database

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

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…