| Author | Topic |
|---|
Location:
Sydney
Registered:
July 2002
|
|
Re: HELP! SQL Query for Uni...
|
Tue, 28 October 2003 23:55
 
|
 |
how do you do an inner join in "Standard SQL"? I can write it in sql for oracle.
also, always structure your SQL statements nicely. Start the Select/from/where/and on a new line.
SELECT RepairLog.*, Techicians.chargeperhour
FROM Techicians, RepairLog, PCDetails
WHERE RepairLog.technicians_id = Technicians.technicians_id
AND PcDetails.pc_id &= RepairLog.pc_id
note: some databases use *= or other ways defining innner joins.
I don't understand the statement though as why are you inner joining PCDetails if your not using it to link to another table and your not using any of the details in there. Is it just selecting the ones that actually have some PCDetails? If so then the above statement should work (without a database to test it on who knows??).
|
|
|
| | 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 |
