Author | Topic |

Location: ballarat
Registered: April 2003
|
Re: HELP! SQL Query for Uni...
|
Tue, 28 October 2003 06:06

|
 |
rough gestimate, but ill give it a try...
select repairlog.*, technicians.chargeperhour from technicians, (select * from pcdetails, repairlog where pcdetails.pc_id = repairlog.pc_id) where technicians.technicians_id = repairlog.technicians_id
im not big on databases, but maybe it'll steer you in the right direction
|
|
|
| Subject | Poster | Date |
 |
HELP! SQL Query for Uni...
|
ZZT231 | Tue, 28 October 2003 03:24 |
 |
Re: HELP! SQL Query for Uni...
|
ehendrikd | Tue, 28 October 2003 06:06 |
 |
Re: HELP! SQL Query for Uni...
|
SupraPete | Thu, 30 October 2003 05:53 |
 |
Re: HELP! SQL Query for Uni...
|
Nark | Tue, 28 October 2003 09:40 |
 |
Re: HELP! SQL Query for Uni...
|
ZZT231 | Tue, 28 October 2003 21:35 |
 |
Re: HELP! SQL Query for Uni...
|
ZZT231 | Tue, 28 October 2003 21:38 |
 |
Re: HELP! SQL Query for Uni...
|
SupraPete | Tue, 28 October 2003 23:55 |
 |
Re: HELP! SQL Query for Uni...
|
ZZT231 | Wed, 29 October 2003 06:14 |
 |
Re: HELP! SQL Query for Uni...
|
SupraPete | Wed, 29 October 2003 06:45 |
 |
Re: HELP! SQL Query for Uni...
|
gtman | Thu, 30 October 2003 02:41 |
 |
Re: HELP! SQL Query for Uni...
|
SupraPete | Thu, 30 October 2003 02:49 |
 |
Re: HELP! SQL Query for Uni...
|
ehendrikd | Thu, 30 October 2003 05:32 |